Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Won't accept sheet name
I'm adding this line of code to save the current sheet name to retrieve
later. When I enter it, I get an "Compile error, expected list separator or )" error and it highlights the "s4". I have nearly the exact same line of code elsewhere in the program and it works fine, just has a different sheet and cell location. sheets ("County Records).Range("s4")= ActiveSheet.Name Any ideas why this is happening here? I'm just trying to save the sheetname so I can put in a button/macro to return to the source sheet when I'm done with this one. Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want a cell should 2 accept only =0 or <=30 or Y or N | New Users to Excel | |||
Accept or Reject a value | Excel Worksheet Functions | |||
Track/Accept Changes | Excel Worksheet Functions | |||
license box accept | Excel Discussion (Misc queries) | |||
Accept on condition only ! | Excel Programming |