View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cellist cellist is offline
external usenet poster
 
Posts: 24
Default Application.Goto Reference gets error 1004

I get "Run-time error 1004, Reference is not valid" when I execute
Application.Goto Reference:="AccountAbbreviations"
Selection.ClearContents
The name "AccountAbbreviations" is, in fact, not defined. How can I check
for not defined so that the code can continue?

TIA,

Phil