View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AndreasHermle AndreasHermle is offline
external usenet poster
 
Posts: 26
Default renaming named ranges

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