Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining series range for named range
I need to create a bunch of named ranges. The series range I want to use
would be created using this OFFSET formula I want do do the following: For i = 2 To Cells(Rows.Count, "A").End(xlUp).Row seriesrange = OFFSET(Statics!$C$1,MATCH(Statics!$C:$C,Statics!$B $1)-1,0,COUNTIF(Statics!$C:$C,Statics!$B$1),3) Next I Anything that reads Statics!$B$1 will be replaced with Cells(i, 2) What needs to change so that seriesrange is dynamically determined based on the value of Cells(i,2)? Thanks in advance, Barb Reinhardt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking up a returned value defining a named range | Excel Discussion (Misc queries) | |||
Defining a custom-named Range across several worksheets | Excel Worksheet Functions | |||
Defining Named Range for Lastrow in a specific column | Excel Discussion (Misc queries) | |||
Defining a named range for a dynamic result set | Excel Programming | |||
Defining maximum value from a named range for charting purposes | Charts and Charting in Excel |