Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Say I have something simple like the code below: for aaa = 1 To 2 For wksh = 1 To 5 Sheets.Add ... ' change active sheets in here ... ' Now I might want to go back to fifth sheet created Next wksh Next aaa .... more code ' again, I may want to go back to the fifth sheet created .... more code The program above creates 10 sheets. I need to go back later to some of the sheets (say I know I want to go back to worksheet 5). How can I select that particular sheet (either in the loop or after I am out of the loop)? I can't say sheet(5) select, because there may have been more sheets created before these loops were run. How can I do something in this to make these sheets identifiable so I can update them later in the code. Thanks Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Loop question | Excel Discussion (Misc queries) | |||
Loop question | Excel Discussion (Misc queries) | |||
Loop QUESTION to end of data range... | Excel Worksheet Functions | |||
Loop QUESTION to end of data range... | Excel Worksheet Functions | |||
Password Loop question. | Excel Discussion (Misc queries) |