Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Special Cells Column Width (03)

    I would like to copy an area (visible cells only) of a worksheet to another workbook but retain each column's width. I'm not sure as how to retain the column width.

    Your thoughts are appreciated.

    Thanks,
    John

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Special Cells Column Width (03)

    Solution:

    Selection.PasteSpecial Paste:=xlPasteColumnWidths

Posting Permissions

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