Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting all sheets
Hi Erin
You need a loop Sub test1() Dim Arr() As String Dim N As Long Dim Sh N = 0 For Each Sh In ThisWorkbook.Sheets If Sh.Visible = True Then N = N + 1 ReDim Preserve Arr(1 To N) Arr(N) = Sh.Name End If Next Sh ThisWorkbook.Sheets(Arr).Select End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting all sheets
Thanks, works perfectly!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting sheets - II | Excel Discussion (Misc queries) | |||
Selecting all sheets | Excel Programming | |||
Selecting sheets without specifying | Excel Programming | |||
Changing the value in multiple sheets without selecting those sheets | Excel Programming | |||
selecting sheets | Excel Programming |