Permanently link formula references to Column Names and not Column Cell Numbers
 

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

Permanently link formula references to Column Names and not Column Cell Numbers
 

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