Hi all
Maybe a newbie question but I can't find the correct answer.
How can I check if a named range exists?
The next step would be to delete it.
Thanks in advance
Hein
Hi all
Maybe a newbie question but I can't find the correct answer.
How can I check if a named range exists?
The next step would be to delete it.
Thanks in advance
Hein
Last edited by Hein; 07-14-2010 at 09:19 AM.
Simplest method is an error handler:
![]()
On Error Resume Next Activeworkbook.Names("your name here").Delete on error goto 0
Everyone who confuses correlation and causation ends up dead.
Easy and a method I haven't thought of, obviously
Thanks for your input
Hein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks