A
AndreasHermle
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
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