LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
filter for missing values in a range billnock Excel Discussion (Misc queries) 1 January 30th 10 11:01 PM
Missing blank in Dynamic range Graham Haughs Excel Worksheet Functions 5 August 4th 06 10:59 PM
Rounding a large range & a Missing Font Jay New Users to Excel 1 May 21st 06 06:50 PM
Missing Numbers from a Range robmeister Excel Programming 3 June 16th 05 01:03 PM
Missing Data in a Range Jeff Green Excel Programming 5 September 21st 04 11:32 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"