Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm writing a sub that works thru a worksheet adding named ranges for all of
the values in a given column (the values are person's names); and I am naming these "named ranges" effectively the same as the person's name (ex: the person's name might be "Tom", so the range is named "Proj_mngr_Tom") one of the values person's name has a "-" (Ju-Li) which is causing an error... is there away of stripping the "-"? (I am presuming I'll need to write a sub that cycles thru each letter, checking its value...) thank in advance -mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i "link" two sets of named ranges | Excel Discussion (Misc queries) | |||
Adding hh:mm times in a row as part of a "named" cell | Excel Worksheet Functions | |||
Defining Multiple "named" data ranges for Piot Tables in Excel 200 | Excel Discussion (Misc queries) | |||
No idea what "Named Ranges" are. | Excel Discussion (Misc queries) | |||
a lot of "ExternalData" Named Ranges | Excel Programming |