select all cells in between two named range

[raj soni]

hi ,
i am trying to select all cells in same column which are in between/including two named ranges.
first : team members
second is space , blank cell ....
also this named ranges occur multiple times in same column .
so i want to make sure it is selected as many times it occurs .
for example : first time it occurs in between a1:a15 second time in between a20:28 and so on ....

[sintek]

Is this the same requirement as per this post....
https://www.excelforum.com/excel-pro...ific-text.html
See upload...

Please Login or Register  to view this content.

[raj soni]

hi , i think theres some confusion ,
i have attach sample file for better understanding .
plz check

[sintek]

Please Login or Register  to view this content.

[sintek]

With the Union Select at end of above code...to select all stored ranges, it is dependant upon value of ii after loop so won't really work...Any ideas on a fix

[sintek]

.....................................

[sintek]

.....................................

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[raj soni]

hi , yes its not working ....also there are many cell having text as "team members" and blank/empty cell after that ...

[JOHN H. DAVIS]

hi , yes its not working ....also there are many cell having text as "team members" and blank/empty cell after that ...

Are you referring to Post #8?

[raj soni]

not working , thanks for giving it try

[raj soni]

yes both not working

[JOHN H. DAVIS]

Worked for me on your sample in Post 3. What do you want to do once the cells are selected?

This colors the ranges red:

Please Login or Register  to view this content.

[sintek]

See amended code....
Selects all required ranges at once as per request...

Please Login or Register  to view this content.

[raj soni]

See amended code....
Selects all required ranges at once as per request...

Please Login or Register  to view this content.

hi , i am getting error " subscript out of range "

[sintek]

Works on your upload file...Upload file you are testing...

[raj soni]

Worked for me on your sample in Post 3. What do you want to do once the cells are selected?

This colors the ranges red:

Please Login or Register  to view this content.

HI , thanks mr.john ....its working ....

[raj soni]

thanks mr.john and mr.sintek.....you saved my time

[sintek]

So what happened to wanting to select all ranges at once....

See this thread I posted...very similar to a cross post...but Not.....It was driving me insane...CK176 perfect solution...
https://www.excelforum.com/excel-pro...ml#post4706865

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback and the reps.