[Excel Dumbo]

Hello,

I have a formula in which the references are cell numbers. I would like to permanently link the references to column names, so when i add/delete columns the references in the formula will not change.

thanks
Excel Dumbo

[GS[_2_]]

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