Copy and Paste for columnwidth
 

Maybe these results copied from the immediate window will help you :

?xlPasteValues
-4163
?xlValues
-4163
?xlPasteFormats
-4122
?xlFormats
-4122
?xlPasteColumnWidths
8
?xlColumnWidths

i.e. the last value is undefined.

NickHK

"xk" wrote in message
...
Hi,

I need to do copy and paste special from one sheet to another sheet by
macro, for the whole thing include : value, format and column width, my
macro works for value and format, just can't done for column width.
Here is the part of my code:

With Worksheets(Worksheets.Count).Range("A7:Q57")
.PasteSpecial xlValues
.PasteSpecial xlFormats
.PasteSpecial xlColumnWidths
End With

.PasteSpecial xlColumnWidths is debuged wrong , anyone have an idea about
it?

Thanks a lot

xk