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

[Excel Dumbo]

Hello,

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

thanks
Excel Dumb

+-------------------------------------------------------------------
|Filename: Book1.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=768
+-------------------------------------------------------------------

 

[GS]

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