PC Review


Reply
Thread Tools Rate Thread

Combining Variable Sized Ranges

 
 
Joe
Guest
Posts: n/a
 
      25th Nov 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
looking for matches from 2 different sized ranges Bruceskin Microsoft Excel Programming 0 22nd Nov 2009 04:26 AM
How do I sum different sized ranges? darkfeld Microsoft Excel Worksheet Functions 3 26th Nov 2008 11:44 PM
Finding Min & Max using lookup & variable sized ranges? Jay Microsoft Excel Discussion 1 18th May 2007 03:45 PM
Counting variable ranges and auto-summing variable ranges Father Guido Microsoft Excel Programming 2 29th Mar 2006 04:07 AM
Variable sized combo box Bruce Microsoft Excel Programming 1 10th Aug 2004 09:28 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:43 PM.