about delete
go into tools=Options and select R1C1 referencing in the general menu.
Now go back and change it back by unselecting R1C1.
You should be prompted for names that Excel is having problems with as to
whether you want to delete them or not. Hopefully your problematic name
will be presented.
This was a hint posted in the newsgroups a while back - I haven't had the
opportunity/need to try it.
--
Regards,
Tom Ogilvy
"gus" wrote in message
...
I have a range name "FLOW" and i can't delete it from
menu (insert-define-name etc") because the last character is strange to
excel .
When i am trying to delete it from menu, or change the reference it
creates
a new name without the last character "".
So i thought to delete it from vba without give the whole name of the
range
name.
|