Select Rows between 2 ranges

**tbrozovich** · 07-21-2015, 10:49 AM

Hi,

I am trying to select entire rows between two named ranges (not including the named ranges). The named ranges are rows already but I cant figure out how to select the rows inbetween.

I have SortPointT = Schedule!$12:$12
I have SortPointB = Schedule!$15:$15

I need to be able to select rows 13 and 14.

These ranges are dynamic vertically. Let me know if you need any more information!

Thanks

**Rioran** · 07-21-2015, 11:00 AM

Hi there!

May be this will inspire you to solve your task:

Please Login or Register  to view this content.

**tbrozovich** · 07-21-2015, 11:29 AM

It is very close! I had to swap the Range("$12:$12") to Range("SortPointT") so it was dynamic but got the proper selection!

So simple I don't know what I was thinking. Thanks for your time!

Have a nice day as well!

Select Rows between 2 ranges

LinkBack

Thread Tools

Rate This Thread

Display

Select Rows between 2 ranges

Re: Select Rows between 2 ranges

Re: Select Rows between 2 ranges

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Select all ranges

[SOLVED] How do I select and copy ranges of about 5000 rows based on sets of criteria?

How do I select and copy ranges of indefinite numbers of rows based on sets of criteria?

Using Variables in Ranges to select entire rows or columns

Code to prevent user to Select COLUMNS but allow to select ROWS

Select Multiple Ranges

Select 2 ranges at once

how do you multiple select and delete rows that the data you select are in

Bookmarks

Bookmarks

Posting Permissions