Using column labels instead of column numbers
 

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

Using column labels instead of column numbers
 

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

Using column labels instead of column numbers
 

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

.