Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello.
I have several sheets, named A, B, C, D, ...., 1,2,3,.....and so on in a workbook. I want to do job WWW in each sheet named 1,2,3,...(not A,B,C,...) when I tried with For kkk = 1 to 15 sheets(kkk).select WWW next kkk it changes from sheet A. I understand sheets(kkk) means kkk-th sheet in a workbook. How do I specify a sheet named variable kkk ? Say, I want to select sheets("1") at first, then sheets("2"), and so on... thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code in certain sheets | Excel Worksheet Functions | |||
Code to hide sheets | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
Vba code to print all sheets | Excel Programming | |||
Same code in several sheets.. | Excel Programming |