VBA to select all ranges stored in array at once

Hi all

Was working on some code for OP...I got to a point where I wanted to select all the ranges stored in the array at once and did not know how to....
The workaround is code in red....However only works in this case but is dependent upon the value of ii after the loop.
Please put me outta my misery...Thanks.

Please Login or Register  to view this content.

This may help explain

Please Login or Register  to view this content.

Hi guys...

Thanks for responses..I understand the concept however am trying to incorporate.
The specific ranges are not known....Need to be found then stored, then all selected at once....
See attached...

Try...

Please Login or Register  to view this content.

@CK76

Excellent solution, thanks...A more suitable solution I might add...Works flawlessly, however, still does not put me out of my misery....
Need to fix my code if possible....Driving me crazy....

Really...is this it...

Please Login or Register  to view this content.

Edited...
So much still to learn...

@ CK176...do understand your part...

Please Login or Register  to view this content.

Is this, however, the only fix....to my code or am i missing something....

Please Login or Register  to view this content.

Well, one thing. You are doing "ReDim Preserve" AFTER you add 1 to ii. That's causing array to add blank element.

So you should remove "ReDim Preserve RngArr(0)"

And change code inside your IF statement to something like below.

Please Login or Register  to view this content.

Edit: Alternately you can check if "RngArr(iii) Is Nothing" and skip if it is.

Cool bananas..Tx