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

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.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=163923

Microsoft Office Help

Thank you Joel.

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

Sean

"joel" wrote:


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.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=163923

Microsoft Office Help

.