why pasteSpecial formats but still colwidth not big enough?

[Ian Elliott]

I have a macro that copies and pastes worksheets from
another workbook. One of the worksheets pasted in has
cells with '######'s-the column widths are not big enough
for the numbers in the cells. The code in my macro is:
Selection.PasteSpecial Paste:=xlPasteFormats
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
Selection.PasteSpecial Paste:=xlPasteColumnWidths

And since the original worksheet columns are wide enough
to not get "######'s I figure the destination should be
fine also. But I have this problem. Any ideas? Thanks!

 

[Ron de Bruin]

which Excel version you use Ian?

 

[Dave Peterson]

And if you're using xl2k, change xlPasteColumnWidths to 8.

 

[Ian Elliott]

I use ver. 2002 Ron...

-----Original Message-----
which Excel version you use Ian?

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)







.