Hi and thanks in advance,
I have a list of names and corresponding range addresses in a sheet that I would like to create named ranges from in VBA. I have that part working ok but I would like to validate each name before I create the named range, in case the name has reserved characters, references a cell address, too long etc which will cause my 'add name' code to crash.
Is there a simple way I could do this in VBA?
Kind regards
Deutz
I have a list of names and corresponding range addresses in a sheet that I would like to create named ranges from in VBA. I have that part working ok but I would like to validate each name before I create the named range, in case the name has reserved characters, references a cell address, too long etc which will cause my 'add name' code to crash.
Is there a simple way I could do this in VBA?
Kind regards
Deutz