Using column labels instead of column numbers

[Sean Bishop]

I am using Excel 2000

I want to create a module to avoid using a lage number of complex formulas.

In Excel (Options) you can elect to use labels in formulas.

Can I use labels in a module and if I can, how do I reference them?

The reason for this is that I have to pass the spreadsheet on and the user
is likely to insert columns, or reorder the columns, without thinking of the
consequences.

What I am hoping is that by using labels, if the column is moved the
calculations will still work as they will still be referncing the correct
data.

I am doing a job which would be better, and more easily, done in a database
but that option is not available to me.

Thank you in advance for any help or assistance you can give me.

Sean Bishop

 

[joel]

On the worksheet menu use

Insert - Names - Define


On the worksheet use the name as the reference like in any formula

In VBA use Ragne("ABC") wiht the named range in double quotes.

 

[Sean Bishop]

Thank you Joel.

Once you had told me the answer was obvious but thank you anyway

Sean