Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |