Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Permanently link just a single column between multiple sheets? | Excel Discussion (Misc queries) | |||
The column names (A,B,C, etc...) changed to numbers?????????? | Setting up and Configuration of Excel | |||
Format column to link file names in that column | Excel Discussion (Misc queries) | |||
Column references changed from letters to numbers | New Users to Excel | |||
copy formula down a column and have cell references change within formula | New Users to Excel |