| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Activate sheets within a loop
I want to loop through a list of sheets, why won't the following code allow
me to activate a sheet? Thanks for your help in advance! Sub LoopThroughSheets() Dim wSheet As Worksheet i = 5 wSheet = Sheets("Print Tracks").Range("G" & i).Value Do While wSheet < "" Sheets(wSheet).Activate Calculate i = i + 1 wSheet = Sheets("Print Tracks").Range("G" & i).Value Loop End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
| visual basic - select/activate but don't show sheets | Excel Programming | |||
| Activate Sheet Best Practice (Y/N?) when xFer data between sheets? | Excel Programming | |||
| Activate all sheets | New Users to Excel | |||
| Any difference between Sheets Activate and Select? | Excel Programming | |||
![CM4@FL[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
