View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Deanne[_2_] Deanne[_2_] is offline
external usenet poster
 
Posts: 1
Default 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