print consecutive cells in a row

[BartH_NL]

Hello,

I have a worksheet in which I have to cycle through a selection of non-adjacent cells in multiple columns and rows,
I first need to cycle the first row, then the second, and so on.
(See attached file.)

I would expect B2 C2 D2 F2 G2 H2 B3 C3 D3 F3 G3 H3 B4 C4 D4 F4 G4 H4

but I get B2 C2 D2 B3 C3 D3 B4 C4 D4 B2 C2 D2 B3 C3 D3 B4 C4 D4

How could I achieve the expected outcome?

[Sintek]

How could I achieve the expected outcome?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jindon]

I would expect B2 C2 D2 F2 G2 H2 B3 C3 D3 F3 G3 H3 B4 C4 D4 F4 G4 H4

Please Login or Register  to view this content.

[BartH_NL]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you/baie dankie, sintek.

So your solution is to change the reference of the cell ranges (Range("B2:D2,F2:H2,B3:D3,F3:H3,B4:D4,F4:H4"))

In real life, these ranges would be selected manually by users and I don't presume I can get them to select the ranges row by row.
They would select two (as in the example) or more blocks of cells.

Nevertheless, your answer triggered me to write this procedure:

Please Login or Register  to view this content.

and that gives the desired result, so thanks for the inspiration!
Then again, this will only work well if a regular selection is made and not something like (see attached image)

[BartH_NL]

I found a solution that also works for irregular selections:

Please Login or Register  to view this content.

[BartH_NL]

Please Login or Register  to view this content.

Hello Jindon,

Thanks for your reply.

I changed it to work with any selection but then find that not all cells are addressed:

Please Login or Register  to view this content.

[Sintek]

I found a solution that also works for irregular selections:

Well done...Rep points for you...