Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear Experts:
I got a workbook with a lot of named ranges. They are named range1, range2, range3, range4 .....range40. Is it possible to ADD a ZERO before the SINGLE digit named ranges (using VBA) so that they look like as follows: range01, range02, ... range09 ... . Ranges named range10, range11 .... range40 etc. are to be left untouched. Help is much appreciated. Thank you very much in advance. Regards, Andreas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... | Excel Programming | |||
Excel {2007} Named Ranges: Renaming, Deleting etc... | Excel Discussion (Misc queries) | |||
renaming a named range | Excel Discussion (Misc queries) | |||
Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
Systematically Renaming Ranges | Excel Programming |