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