| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Reference Dynamically
Hi,
On my Data Worksheet, I have defined DataAmt as A1:A65000. How can i change it to some other value ex. A1:A100 ? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing Reference Dynamically
Shashi,
You can try the following: Range(Range("A1"), Range("A65536").End(xlUp)).Name = "DataAmt" The above will create a named range (DataAmt) from A1 to the last cell in column "A" that contains a value (or text). John Shashi Bhosale wrote: Hi, On my Data Worksheet, I have defined DataAmt as A1:A65000. How can i change it to some other value ex. A1:A100 ? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically changing cell's formula | Excel Worksheet Functions | |||
| Changing a formula dynamically. | Excel Worksheet Functions | |||
| changing selections dynamically | Excel Discussion (Misc queries) | |||
| Dynamically changing the size of a list | Excel Discussion (Misc queries) | |||
| Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Linear Mode
