Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting all sheets
I need a piece of VBA code that will select all visible sheets.
Just a slightly different technique: Function SelectAllSheets() '// Dana DeLouis Dim sht As Variant On Error Resume Next For Each sht In Sheets sht.Select Not sht.Visible Next 'Return a count SelectAllSheets = ActiveWindow.SelectedSheets.Count End Function -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "Erin" wrote in message ... I need a piece of VBA code that will select all visible sheets. When I record a macro, it does it via an array and specifying each sheet name. But, in my case I don't know how many sheets there are. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting sheets - II | Excel Discussion (Misc queries) | |||
Selecting sheets without specifying | Excel Programming | |||
selecting sheets in vb | Excel Programming | |||
Changing the value in multiple sheets without selecting those sheets | Excel Programming | |||
selecting sheets | Excel Programming |