ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combining Variable Sized Ranges (https://www.excelbanter.com/excel-programming/420505-combining-variable-sized-ranges.html)

Joe

Combining Variable Sized Ranges
 
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?


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com