Hi Dave, I was already thinking at some code like yours... I don't think it's possible without vba.
I have some problems with your code :
- the selections are copied one above the other, starting at cell B3, so instead of Offset(2, 1) there must be something to count the lines of the selection
- the ColumnWidth and RowHeight in the sheet 'MyPrintSheet' are not like the original cells
- for the cells where formula's are used, i get a error (solution : paste only values ?)