Hi,
I have just started to use Macros. I hope I can get assistance from the kind people of this community.
Did my first tutorial.
Objective: To move to sheet2 and select cell c5 I put the following in the module in VBA:
Sheets("sheet2").Range("C5").Select
I wanted to know why I getting the error: select method of range class failed
TIA
I have just started to use Macros. I hope I can get assistance from the kind people of this community.
Did my first tutorial.
Objective: To move to sheet2 and select cell c5 I put the following in the module in VBA:
Sheets("sheet2").Range("C5").Select
I wanted to know why I getting the error: select method of range class failed
TIA