Hi John,

Yes thats the right way to refer to a cell in a worksheet.
Do you have the code in a sheet? Try putting the code in any modeule
and run from there.

Regards
Ankur Knahcan

www.xlmacros.com




John Smith wrote:

Steven wrote:
vGoToSheet = ActiveCell.Value
Sheets(vGoToSheet).Select
Range("A3").Select

Question: How do you tell excel to go to Range("A3") in the sheet you just
select. They way it is above causes an error on the Range("A3").Select

Thank you,

Steven

Cells(3,1).select