copy contents of a sheet to another with the exact column width and row height

**prajesh** · 12-25-2011, 04:42 AM

hi all,
i had written a vba code to copy contents of a sheet to the display sheet...
it does that fine, formatting is same but column width and row height has been adjusted in the original which is all gone when it copies...
that creates a whole lot of mess...and compels me to adjust height and width all over again...
how could i correct this one?

pike, hi...

thanks in advance

**prajesh** · 12-25-2011, 06:02 AM

if anyone needs it, i go the answer...
add the following line to the code :

Please Login or Register  to view this content.

**prajesh** · 12-25-2011, 06:03 AM

if anyone needs it, i got the answer...
add the following line to the code :

Please Login or Register  to view this content.

**WasWodge** · 12-25-2011, 06:18 AM

Prajesh, did the row height adjust for you as well as the column width?
Only the column width worked for me using 2007 (I haven't tried it with 2010 yet). That is what I would expect as the column width is the only one in the paste special dialog box when I do it manually in 2007.