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
|