Paste Special Macro

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.
 
P

Patrick Molloy

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

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

Ron de Bruin

This is a known bug

Use this instead (working in all versions)

PasteSpecial Paste:=8
 
Top