VBA Select method (Easy Question of the Year)

Posted by Kurt on July 13, 2001 7:00 AM

Hi All,

Still getting my VBA feet wet. All I want to do to start off a macro is select all the sheets in the active workbook. If you can help I'd appreciate it.

Thanks.

Kurt

Posted by Ivan F Moala on July 13, 2001 7:08 AM

Kurt

Sub SelectAllSheets()
Dim sh As Worksheet

For Each sh In ActiveWorkbook.Sheets
sh.Select False
Next
End Sub

Ivan