| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cycling through worksheets
Hi,
I'm cycling through the worksheets of a workbook extracting their name. I'm using the following code which is "clunky" - what's a better way of doing it..?? For Each sheet In ActiveWorkbook.Worksheets sheet.Activate my var = ActiveSheet.Name Next sheet thks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tab keeps cycling through the same row | Excel Discussion (Misc queries) | |||
| Cycling through workbooks | Excel Discussion (Misc queries) | |||
| Anyone out there knows of running cycling and swimming logs? | Excel Discussion (Misc queries) | |||
| Open a Read-Only File by cycling thru these 5 passwords | Excel Programming | |||
| Need UDF help; cycling through various sheets using VBA name property | Excel Programming | |||
![Chris Gorham[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
