| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks Guys - much appreciated.
"Duke Carey" wrote in message ... Press the F5 key, type in your dynamic range name, click on OK, and Excel will select the range. In your case, your defined range will NOT INCLUDE the last number in the list. Either change the offset to reference cell A2, or add 1 to the COUNT(A:A) "Andibevan" wrote: Hi All, I am having problems with dynamic named ranges. On my table I have defect ID's (numerical) running from a2:a200 and the title"Defect ID" in cell A1 I am using the following formula to dynamically name a range:- =OFFSET($A$1,0,0,COUNT($A:$A),1) Will this format of offset select A1:A200 as the named range or A2:200? From my understanding you can't physically select a dynamically named range so it is hard to tell what it is selecting Thanks Andi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find all named ranges in VB.NET? | Excel Discussion (Misc queries) | |||
| Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
| Indirect and dynamic ranges | Excel Worksheet Functions | |||
| Problem with graph ranges | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Hybrid Mode
