I am sure that this is an easy question, so here goes.
Currently in VBA i can reference a cell as (useing cell H8 as an example)
However if i insert a column before column H then all the VBA's go out of whack.
Is there a way that i can name the columns and then refer to them by their name so that a column add/remove isnt breaking all the scripts? if it helps each column in row 1 holds the Unique identifyer for that column (Name, Address, Phone, etc....)
Cheers for any solutions.