Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet name
hi,
I have the following: For x = 1 to 30 dim previoussheet as string previoussheet = "acct" & x-1 set sh = worksheets(previoussheet) if not sheetexists(sh) then .... i think there is a problem with the following line: set sh = worksheets(previoussheet) because the standard syntax is usually something like: set sh = worksheets("previoussheet") i am not sure what to do. could someone help? thanks in advance, geebee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
Export sheet store sheet import sheet. | Excel Programming | |||
Copying cells from on sheet to another sheet (via sheet module) | Excel Programming | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |