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 |
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 |
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 |
Range("Reset Sheet!F13").Select Makes VBA Code Fail
Thanks Jim and Gary. |
All times are GMT +1. The time now is 05:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com