Iterate through merged range

[MrFoxar]

I'm trying to iterate through a range of merged cells, but each cell in the merged row is being iterated through and I want it to go from row to row.
This what I have, but the subscript goes out of range since is looking at the cells within the merged rows.

Please Login or Register  to view this content.

[JBeaucaire]

Add this to the loooooong LIST of reasons to NOT use merged cells.

Excel provides the "Center across Selection" option so cells look merged but are not, so why use anything else?

[shg]

Merging cells is a universally bad idea when there is any related downstream processing.

Maybe this will work (completely untested):

Please Login or Register  to view this content.

[MrFoxar]

Thanks,

I kept the code as is and change the format to center accross selection.
That was a bit of a challenge, but it worked out great. Thanks for the tip. I imagine that I will do it that way from this point on.

The challenge was that I had to insert a "spacer" column between the areas which were being populated; otherwise the data would center accross selections in cases were there was no data.

I'm sure a more graphical explanation would better explain what I am doing, but suffice it to say the problem has been solved, and once again, thank you.

[JBeaucaire]

Glad to hear it. If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)