| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I specify these date-range formulas? | Excel Discussion (Misc queries) | |||
| how to sum up a range of formulas? | Excel Discussion (Misc queries) | |||
| how to copy formulas from one range to another range in other work | Excel Programming | |||
| excel range formulas | Excel Worksheet Functions | |||
| How do you set up range names, name formulas | Excel Worksheet Functions | |||
Linear Mode
