S
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
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