I am copying several rows on a worksheet, each column has a width value set. When I do a simple copy and past (even selecting Past formats) the column widths are lost.
How do I copy these rows and maintain column widths on my new worksheet?
I am copying several rows on a worksheet, each column has a width value set. When I do a simple copy and past (even selecting Past formats) the column widths are lost.
How do I copy these rows and maintain column widths on my new worksheet?
Regards
Rick
Win10, Office 365
Hi,
I'm helping myself for simmilar problems (changing row widths) with VBA. I think best option would be to use this code :
You could put Cmdbutton on your sheets and run this code each time you copy rows. That will work If you copy them in same columns as previous sheet. You could also preform this code for all sheets at once, something like :Please Login or Register to view this content.
hope this helps !Please Login or Register to view this content.
One way to do this is after pasting the copied rows, right click again --> Paste Special --> Column Width --> OK.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks