Thread: copy paste (column width prb)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
  
Posts: 184
Default copy paste (column width prb)
Hi Murat,
Sheets(1).Range("A1").PasteSpecial Paste:=xlValues
Sheets(1).Range("A1").PasteSpecial Paste:=xlFormats


There is a BUG in excel with paste special:

You should be able to use
Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteColumnWidths

HOWEVER, this does not work, so you have to use
Sheets(1).Range("A1").PasteSpecial Paste:=8
instead.

regards

arno


Reply With QuoteReply With Quote