+ Reply to Thread
Results 1 to 2 of 2

Create new worksheet keeping source column widths

  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    1

    Create new worksheet keeping source column widths

    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

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Create new worksheet keeping source column widths

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1