Posted to microsoft.public.excel.programming

Deanne[_2_] Deanne[_2_] is offline

external usenet poster

Posts: 1

Goto method fails when assigning a macro to a button

I have written a macro that includes a Goto Reference. If
I run the macro from the worksheet it works.

I want to assign this macro to a Command Button. The
result is a Run-time error '1004': Method 'Goto' of
object '_Application' failed.

Can any one suggest another way? My Goto Reference is a
named range of cells.

I use the outdated Excel 97.

Please help!

Thanks,

Deanne

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning a macro to a button	hberg	Excel Worksheet Functions	1	January 27th 10 10:31 PM
Assigning A Macro to A Button	Holly	Excel Worksheet Functions	1	January 18th 08 10:04 AM
assigning macro to button	BorisS	Excel Discussion (Misc queries)	2	September 12th 05 05:08 AM
Assigning macro to button	d	Excel Discussion (Misc queries)	0	August 22nd 05 01:40 PM
Assigning a macro to a "button"	Yvon	Excel Discussion (Misc queries)	6	February 8th 05 10:58 PM

All times are GMT +1. The time now is 02:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us