Hi all,
I'm looking for a way to delete all named ranges starting with ProfitCenter
The macrorecorder doesn't give me any clues.
Thanks in advance
Hein
Hi all,
I'm looking for a way to delete all named ranges starting with ProfitCenter
The macrorecorder doesn't give me any clues.
Thanks in advance
Hein
Last edited by Hein; 01-28-2009 at 09:28 AM.
In what sense does the macro recorder not help.
You will have to expand on what you mean by "all named ranges starting with ProfitCenter". What is special about the start point? Are there names that should be left alone?![]()
Please Login or Register to view this content.
Hi Andy
Thanks for your reply
Names will look like ProfitCenter_1, ProfitCenter_2 etc
Will changing your code to
help?![]()
Please Login or Register to view this content.
Hein
No that would error.
You need something more like this,
![]()
Please Login or Register to view this content.
OK, got it
Thanks Andy
Hein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks