for each sh copy paste value and transpose

Hello,

I copying a (vertical) range from an active sheet (inside a for each sh loop) to a master sheet but in the Master sheet, I need to use paste values and transpose horizontally (in one row)

The following line would copy from vertical to vertical. How would I change this line to do paste values and transpose?

Therow is predefined earlier and is irrelevant for this discussion

Thanks,

Please Login or Register  to view this content.

Hi, Perhaps Something like this:-

Please Login or Register  to view this content.

Mick

Awesome recommendation RoyUK..works like a charm!