You need to look into using the DefineName dialog. Be sure to give your
col names local (sheet-level) scope. You may want to use fully-absolute
refs in your definitions, or column-absolute,row-relative if you intend
on using the name in formulas so they ref columns in the same row as
the formula. (This will auto-adjust for each row, but remain constant
for the col ref)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion