If you copy the sheet in the attached to a new workbook, the column widths go haywire - help!
Thanks in advance.
If you copy the sheet in the attached to a new workbook, the column widths go haywire - help!
Thanks in advance.
Hi tone640,
When I copy and paste to a new workbook, the column widths are the same as the original.
I can't reproduce your problem. What am I missing?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
When I use sheet1.copy in a macro, or the equivalent:
Right click and choose 'move or copy...', then select 'New book' from 'move selected sheets; To book:' and check 'Create a copy'.
bump - I can work around this I'm sure, but it would be nice to understand why, has anyone had something similar happen to them?
Hi -
If you PasteSpecial instead of create a copy in VBA I think you can get what you want. My recorded macro looks like
I think you just have to be mre specific in your paste line of VBA to insure the columns are the same width as the original columnsPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks