I got 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.
Help is much appreciated.
Thank you very much in advance.