View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ToferKing ToferKing is offline
external usenet poster
 
Posts: 41
Default 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