Select cell on another sheet

[tiredofit]

Assume Sheet1 is active.

In a module, I type:

Sub Test


    Sheet2.Cells(1,1).Select


End Sub

This returns a Run-time error '1004:' Select method of Range class failed.


I assume the reason is you must be on the active sheet to select a cell in it.


However, this works if you are NOT on Sheet2:

Sub Test


    Application.GoTo Sheet2.Cells(1,1)


End Sub

so why use the Select method at all?


Thanks

 

[James006]

Hello,

Sub Test()
    Application.GoTo Sheet2.Cells(1, 1)
End Sub

will function irrespective of your activesheet ...

You are right ... Select is very rarely required ...

and GoTo will allow to jump to any location ...

HTH

 

[tiredofit]

Thanks

 

[James006]

You are welcome ...