Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable length named ranges
I need a way to specify a variable for the last row in a named range.
A static definition looks like this: ThisWorkbook.Names.Add Name:="dAge", RefersTo:="=RawData!$H$2:$H$100", Visible:=True I would like to replace 100 with nRows and need help with the syntax. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable length named ranges
I assume that nRows is an integer or long variable...
ThisWorkbook.Names.Add Name:="dAge", RefersTo:="=RawData!$H$2:$H$" & nRows, Visible:=True -- HTH... Jim Thomlinson "adimar" wrote: I need a way to specify a variable for the last row in a named range. A static definition looks like this: ThisWorkbook.Names.Add Name:="dAge", RefersTo:="=RawData!$H$2:$H$100", Visible:=True I would like to replace 100 with nRows and need help with the syntax. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable length named ranges
"Jim Thomlinson" wrote in message
... I assume that nRows is an integer or long variable... ThisWorkbook.Names.Add Name:="dAge", RefersTo:="=RawData!$H$2:$H$" & nRows, Visible:=True I hope the poster understands that the named range is not "connected" to nRows, i.e., if the value of nRows changes later it won't change the range that was just created. Just thought I'd mention it.... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable length named ranges
In addition to other replies do you really mean to add the name to
"ThisWorkbook". From what you followed up with in your other recent I suspect you mean ActiveWorkbook or some other named wb. Regards, Peter T "adimar" wrote in message ... I need a way to specify a variable for the last row in a named range. A static definition looks like this: ThisWorkbook.Names.Add Name:="dAge", RefersTo:="=RawData!$H$2:$H$100", Visible:=True I would like to replace "100" with "nRows" and need help with the syntax. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... | Excel Programming | |||
Counting variable ranges and auto-summing variable ranges | Excel Programming | |||
Counting Variable Length of Rows in a Named Range | Excel Programming | |||
Counting Variable Length of Rows in a Named Range | Excel Programming | |||
Counting Variable Length of Rows in a Named Range | Excel Programming |