Why is this an erorr?
 

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

Why is this an erorr?
 

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