Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to combine to named ranges that vary in size. I am using the Advanced
filter to extract the first range and then do following to size 1st extracted range Application.Goto Reference:="DB_FORMS" Range(ActiveCell, ActiveCell.End(xlDown)).Select Range("DB_FORMS").CurrentRegion.Name = "DB_FORMS" Now I need to go to next blank line, copy a set a field names to extract a new set of data into the 2nd range. How do I go down to the blank line without a cell reference? and how to name or use that set of field names in the 2nd advanced filter? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sum different sized ranges? | Excel Worksheet Functions | |||
Using variable sized range in CountIf() | Excel Discussion (Misc queries) | |||
Variable sized combo box | Excel Programming | |||
Variable sized average macro/function | Excel Programming | |||
Summing a variable sized range programmatically | Excel Programming |