+ Reply to Thread
Results 1 to 3 of 3

Copy multiple ranges

  1. #1
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2016 Office 365 ProPlus
    Posts
    822

    Copy multiple ranges

    So I have a range of data what I have to copy but in the middle there is a breakrow that I do not want to copy.

    I identified the beginrow (brow), the end row (lrow) and the line which I do not want (breakrow).

    I wanted to copy it like this :
    Please Login or Register  to view this content.
    But this will still copy the entire block...

    Using
    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    separately works just fine.
    Why can I not combine the 2 and get it to work?

  2. #2
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2016 Office 365 ProPlus
    Posts
    822

    Re: Copy multiple ranges

    Argh found it....got lost in the " maze

    Please Login or Register  to view this content.
    Found it by putting in the psysical range numbers and make it variable one by one.
    But at least I found it

  3. #3
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    669

    Re: Copy multiple ranges

    HI

    what about
    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)

Similar Threads

  1. [SOLVED] Loop Copy and paste multiple ranges from multiple workbooks
    By Ravenous in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2017, 05:46 PM
  2. How to copy & paste multiple ranges by using VBA Code?
    By toradoya in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-03-2016, 07:05 PM
  3. [SOLVED] Copy multiple ranges from one wbook to another
    By niggzso in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-13-2016, 03:52 PM
  4. Copy/amalgamating Multiple Ranges
    By jennyaccord in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-20-2013, 10:25 AM
  5. VBA Copy Sum formula down column with multiple ranges
    By carlosriver24 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2012, 09:12 PM
  6. Conditional Copy of Multiple Ranges
    By astefanacci in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2010, 05:21 PM
  7. copy ranges from multiple worksheets
    By simora in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2005, 09:06 PM

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