Hi everybody,

I have a large spreadsheet where I want to name ranges in a macro based on
the first two digits in the cells of one column. In the example below I need
to end up with one named range for the 4 codes starting with 11, one range
for the 3 codes starting with 12 and one range for the 2 codes starting with
13.

110003
110024
110035
110594
120012
120014
120045
130455
131004

Any help much appreciated.
--
Regards,

Martin