View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default What Range was Missing

If I issue this command:
application.goto Reference:="MyRange"
and the named range "MyRange" does not exist, is there a way to
programatically pick up the name of the range that the error failed on. I am
using error handling and my initial idea was to place a line above the
command: referencename="MyRange", but if I missed doing this I'd get the
wrong message in my error handling area. So that is the reason for this
question.