about delete
 

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.

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.

about delete
 

No this did't worked couse the range name has this reference in an external
file.
" '[worksheet in presentation ]#ref!#ref "


"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.

about delete
 

Hi Tom,

This was a hint posted in the newsgroups a while back - I
haven't had the
opportunity/need to try it.

It will work. Excel will prompt for a new (valid) name for
each corrupt one it finds (in all open workbooks!). After
that, one can delete the changed names.

Regards,

Jan Karel Pieterse
Excel TA/MVP

about delete
 

Just a thought, but in old school we are taught that you can get those
funkiefied characters by holding down the ALT key, and typing the 3 digit
Extended Ascii code on the numeric keypad (the 10-key pad). For example
holding down the alt+159 on the keypad give you this character : f
Thurman

"gus" wrote in message
...
No this did't worked couse the range name has this reference in an
external
file.
" '[worksheet in presentation ]#ref!#ref "


"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.

about delete
 

Try downloading Jan Karl Pieteriese's Name Manager from Stephen Bullen's
site.

Perhaps it will be able to delete the name:

http://www.bmsltd.co.uk/MVP/Default.htm

--
Regards,
Tom Ogilvy


"gus" wrote in message
...
No this did't worked couse the range name has this reference in an
external
file.
" '[worksheet in presentation ]#ref!#ref "


"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.

about delete
 

You were the one I was quoting, but as you can see in a later post, I kind
of butchered the spelling of your name, so I hadn't attempted it here.
Sorry about the misspelling.

--
Regards,
Tom Ogilvy

"Jan Karel Pieterse" wrote in message
...
Hi Tom,

This was a hint posted in the newsgroups a while back - I
haven't had the
opportunity/need to try it.

It will work. Excel will prompt for a new (valid) name for
each corrupt one it finds (in all open workbooks!). After
that, one can delete the changed names.

Regards,

Jan Karel Pieterse
Excel TA/MVP

about delete
 

Hi Tom,

Sorry about the misspelling.

presonlly I nveer mkae tpoys. <vbg

This is an interesting piece of text:

Aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in waht
oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht the frist
and lsat ltteer be at the rghit pclae. The rset can be a total mses and you
can sitll raed it wouthit porbelm. Tihs is bcuseae the huamn mnid deos not
raed ervey lteter by istlef, but the wrod as a wlohe.

Regards,

Jan Karel Pieterse
Excel TA/MVP