Loop through non-continuous named range in vba

Is this possible?

If I have a named range that covers A1:A10, A12:A15, A17:A20, can I use code that loops through? (Specifically, I'm using a "For each variable In variablelist.... Next".)

I tried running it, and the code seems to end at A10 (last item in first segment of named range), so I'm assuming I either have to use a different type of loop, or some sort of workaround. It would be nice if these named ranges didn't have to be separated to be operated upon. (There are more segments than I listed)

Thanks!

This structure will cycle through each area of the multi-area Named Range:

Please Login or Register  to view this content.

Does that get you headed in the right direction?

Hi awan0126, there are a couple of ways you can loop through.
1. You can set your range

Please Login or Register  to view this content.

or, if you don't know the last row used, you can go with

Please Login or Register  to view this content.

Whole code:

Please Login or Register  to view this content.

EDIT: Sorry Ron to jump in, there was no answer when I was working on it!


Regards:

If the areas are irrelevant, and you really just want to use each "cell" in the whole named range once through the loop, something like:

Please Login or Register  to view this content.

I think JB is right: no need for areas (nor for variables if you use named ranges)

Please Login or Register  to view this content.

If you put a non-contiguous range into a Variant (array), it will only accept the first area.
I you put it in an object variable (using Set =) the whole range will be accepted.

You are mistaken:
Your question was about a named range.
To loop through a named range you don't need a variable at all, like I showed you before:

Please Login or Register  to view this content.