Simple Command Button

[yenrab]

I've created a simple command button to goto a range of cells. The button works but I always get Run-time error 1004 Reference is not valid after it works.
Please advise a beginner. Thanks

 

[AJ]

Not sure why it gives you the error. Is there any other info you can give? How are you defining the reference?

I just threw a command button on a worksheet and added the following and I get no errors.
(Note R1C1 notation of reference)

Private Sub CommandButton1_Click()
Application.Goto Reference:="R30C2:R30C6"
End Sub

Any help??

Rgds
AJ

 

[AJ]

Or, alternatively...

Application.Goto Reference:=Range("A4:N304")

You've gotta use the word "Reference", or else you'll get the runtime error

Rgds
AJ

 

[yenrab]

ok, thanks ill give that a try