When running the below code, I lose the original column widths due to the autofit line. Is there an alternative that lets me maintain my source column widths?
Please Login or Register to view this content.
When running the below code, I lose the original column widths due to the autofit line. Is there an alternative that lets me maintain my source column widths?
Please Login or Register to view this content.
Last edited by davesexcel; 04-12-2013 at 07:46 PM. Reason: Code Tags Required
Something like this will copy the worksheet, then clear the contents keeping the column widths.
You can then continue with the code to transfer the info.
Test it out.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks