Simple Command Button

yenrab · Mar 22nd, 2002, 09:48 AM

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 · Mar 22nd, 2002, 10:01 AM

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 · Mar 22nd, 2002, 10:35 AM

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 · Mar 22nd, 2002, 10:56 AM

ok, thanks ill give that a try

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 09:48 AM	#1
yenrab New Member Join Date: Mar 2002 Posts: 2	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

Mar 22nd, 2002, 10:01 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	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

Mar 22nd, 2002, 10:35 AM	#3
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	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

Mar 22nd, 2002, 10:56 AM	#4
yenrab New Member Join Date: Mar 2002 Posts: 2	ok, thanks ill give that a try