column widths when copying to another sheet

Gday

as per the demo, I select random questions that copy to sheet 2, the formular works well, but as you see by the questions the column and row widths are not copied with the special paste. How can I over come this

here is the formula

Please Login or Register  to view this content.

thanking you
Ozz

hi ozzie4x4

Range.PasteSpecial Method syntax is

expression.PasteSpecial(Paste, Operation, SkipBlanks, Transpose)

one of the "Paste" Data Type is

Please Login or Register  to view this content.

if you highligh Paste special in the code and press "F1" you will find the VBA Help description