well thaught it worked, im getting an error 1004 when trying to cop
columnwidths, heres what i have

Private Sub CommandButton3_Click()
Range("A1:Q22").Select
Selection.Copy
Workbooks.Add
Selection.Insert Shift:=xlToRight
Selection.PasteSpecial Paste:=xlColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub

i get the error at the selection.pasespecial line

--
Message posted from http://www.ExcelForum.com