Combining Variable Sized Ranges

J

Joe

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro needs updated Range name addresses 3
VBA help with selecting multiple data ranges 1
Macro question: Using named ranges 6
Adv Filter fails in macro, works manually 34
Filter, Delete and Error handling - need help 4
Hlp! Adv Filter - Non-Contiguous rows don't copy 11
maintaining the value of a variable outside of an if construct... 1
Repeat the macro using different ranges 1

Top