Paste Special Macro

  • Thread starter Thread starter Partly Void
  • Start date Start date
P

Partly Void

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.
 
either (1) xlPasteAllValues
or (2) cw = source.columnwidth : selection.columnwidth = cw

eg
Range("C1").ColumnWidth = Range("A1").ColumnWidth
 
This is a known bug

Use this instead (working in all versions)

PasteSpecial Paste:=8
 
Back
Top