+ Reply to Thread
Results 1 to 3 of 3

copy sheets (with exception) and paste with line break (have code)

  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    382

    copy sheets (with exception) and paste with line break (have code)

    I am wondering how I can manage to select all visible sheets in my workbook, with MULTIPLE exceptions, and then paste the selected range into one workbook with always one free row after each pasted sheet.

    here my code, hope someone has a sparking idea

    Please Login or Register  to view this content.
    Eg. I want to select all visible sheet except sheet "Summary", as posted above, but as well another sheet called "Report".
    Then, I would need to select cells A2:H200 on all remaining sheets, and once sucessfully copied, paste it onto sheet "Report", but I do not know how to make excel understand to insert a blank row first...

    Thanks,
    A2k

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: copy sheets (with exception) and paste with line break (have code)

    This is how I would do it:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: copy sheets (with exception) and paste with line break (have code)

    Maybe like this (untested)
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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