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.