Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("Reset Sheet!F13").Select Makes VBA Code Fail
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("Reset Sheet!F13").Select Makes VBA Code Fail
You have to select the sheet first, then select the range. However you don't have to select either to enter a value in a range... Worksheets("Reset Sheet").Range("F13").Value = "This sheet is hidden" -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "ToferKing" wrote in message 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("Reset Sheet!F13").Select Makes VBA Code Fail
one way worksheets("Reset Sheet").range("f13").select or worksheets("Reset Sheet").range("f13").value = "This sheet is hidden." -- Gary "ToferKing" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("Reset Sheet!F13").Select Makes VBA Code Fail
Thanks Jim and Gary. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |