either (1) xlPasteAllValues
or (2) cw = source.columnwidth : selection.columnwidth = cw

eg
Range("C1").ColumnWidth = Range("A1").ColumnWidth

"Partly Void" wrote in message
...
Macro stopping on "Selection.PasteSpecial Paste:=xlPasteColumnWidths"
using
Excel 2000. Macro executes Paste Values and Formats. Accepts Paste
ColumnWidths when done manually. Any advice much appeciated.