Using range name in formulas
 

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

Using range name in formulas
 

Hi Gerry

Rather than using 'cells' use 'range'

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

HTH
Trevor Williams

"GC" wrote:

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

Using range name in formulas
 

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

"Trevor Williams" wrote in
message ...
Hi Gerry

Rather than using 'cells' use 'range'

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

HTH
Trevor Williams

"GC" wrote:

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

Using range name in formulas
 

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" wrote in message
...
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

"Trevor Williams" wrote in
message ...
Hi Gerry

Rather than using 'cells' use 'range'

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

HTH
Trevor Williams

"GC" wrote:

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

Using range name in formulas
 

Thank you Patrick.
Gerry
"Patrick Molloy" wrote in message
...
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" wrote in message
...
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

"Trevor Williams" wrote in
message ...
Hi Gerry

Rather than using 'cells' use 'range'

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

HTH
Trevor Williams

"GC" wrote:

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