Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a routine I am writing that causes the current sheet's visible
property to change to false and then takes the user to a Reset Sheet. Once the person gets to the Reset Sheet, I want the routine to select cell F13 and enter the phrase, "This sheet is hidden." Well, I think I am stuck in R1C1 reference versus the other kind of reference - whatever that is called. My routine fails at this line. Range("Reset Sheet!F13").Select I have a feeling my VBA code wants me to use R1C1 type coding, but that won't work because I don't know where the cursor will be when the user is returned to the Reset Sheet. Can you guys help me get this line to work using the specific cell reference? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Result displays "FALSE" instead of "FAIL" | Excel Discussion (Misc queries) | |||
VBA code to "reset" application run and empty preserved arrays | Excel Programming | |||
"Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
Questionnaire sheet: Select "yes" or "no," and only one can be selected | Excel Worksheet Functions | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |