I have a named range "images" that consists of B13:H13,B20:H20...B**:H**.
If I check Range("images").address vba returns the correct non-contiguous range as above.
I am trying to step through this range with a for i loop.
If I check Range("images")(8) the address comes back as B14 not B20.
Any ideas what is wrong and how to fix this?
Correct addresses but not usable as must be part of an existing integer loop
Fills in the gaps in the rangePlease Login or Register to view this content.
Pretty sure this has solved it. Thanks Mark L for the range.areas.cells over range.cells suggestion. If anyone has a better solution feel free to comment.Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks