Stepped loop through splintered range of cells

Well, if that title isn't clear, then I don't know what could be! ;-)

To be honest, apologies for that title - I am trying to do something and I am not sure how.

I get a range of cell addresses from a filtered list, where I only grab the blank cells, like below:

Please Login or Register  to view this content.

This returns: $AR$3,$AR$10:$AR$11,$AR$23:$AR$33,$AR$35:$AR$49,$AR$84,$AR$89:$AR$91,$AR$93,$AR$100:$AR$103,$AR$195,$AR$214,$AR$226,$AR$244,$AR$248,$AR$272,$AR$286,$AR$303,$AR$330,$AR$334:$AR$559

If I say the below, it returns 273 - the actual number of blank cells.

Please Login or Register  to view this content.

but saying 'rng(4).address' doesn't give me the address of the 4th blank cell, but just gives me $AR$6, which is not actually in the range. And saying 'rng(600).Address' just gives me $AR$602... you get the idea, but that's not correct.


What I am trying to do is:

Please Login or Register  to view this content.

Is there a way to do a loop like the above on a jagged range like in the example?
Thanks!