Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columnwidth | Excel Discussion (Misc queries) | |||
ColumnWidth | Excel Programming | |||
ColumnWidth | Excel Programming | |||
Selection.ColumnWidth | Excel Programming | |||
ColumnWidth not working... | Excel Programming |