Hi, I'm using VBA to create some macros in excel 07. I've named several columns and would like to get the column number associated with these names in the VBA code by referencing the names so that I don't have to hard code the column numbers. Is there a way to get the column number by referencing it's name without a particular cell in the column being active?