Digisafenz wrote :
You can give the DV fields' range a local (sheet-level) defined name.
This can be the same name on every sheet so your formulas only need to
ref the correct sheet.
You create a local defined named by prefixing the name with the
sheetname wrapped in single quotes, and separated by the exclamation
Select the range to be named
Type in the NameBox left of the FormulaBar:
..where 'UserChoices' should be similar to the column heading, and so
if your heading is "User Choices" then the defined name associates to
that. **Note that defined names can NOT include spaces, must begin with
an alpha character, and can NOT contain any special characters other
than _ (the Underscore). So.., the defined name could also be
In your formula example...
To make the defined name column-absolute/row-relative you need to use
the Define name dialog...
Select a single cell in any col where the formula is to be used.
Open the Define name dialog and enter the name as described above.
Edit the RefersTo box as follows:
Remove the $ symbol preceeding the row number;
Leave the $ symbol preceeding the column label.
Alternatively, you can use column-absolute/row-relative refs this
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!