Using range name in formulas

[GC]

How do you use a range name within a formula?
example
I have a range (1 cell) called STATUS.
I would like to use my named range in the following formula.

Worksheets("Data").Cells(23, 1).Value = "Running "

Thanks a bunch,
Gerry

 

[Trevor Williams]

Hi Gerry

Rather than using 'cells' use 'range'

Worksheets("Data").Range("STATUS").Value = "Running "

HTH
Trevor Williams

 

[GC]

Hey Trevor, Thank you very much. This is what I was looking for.
I have another question. I wrote a small VP application in my Excel file.
How do I write protect my work or better still, how could I hide or not give
access to the VB part of the Excel file?

Gerry

 

[Patrick Molloy]

in the development environment choose Tools / VBA Project Properties then
the Protection tab.
check the Lock Project box and add a password.
Warning : there are many programs out there on the Web that will crack Excel
VBA.

 

[GC]

Thank you Patrick.
Gerry

in the development environment choose Tools / VBA Project Properties then
the Protection tab.
check the Lock Project box and add a password.
Warning : there are many programs out there on the Web that will crack
Excel VBA.