+ Reply to Thread
Results 1 to 3 of 3

Select non contiguous range within a column

  1. #1
    Registered User
    Join Date
    12-06-2016
    Location
    Paris, France
    MS-Off Ver
    2012
    Posts
    27

    Select non contiguous range within a column

    Hello,

    Sorry if I'm not very clear, english isn't my first language. I'm trying to select range 118:131 and 133:135 in the currently selected column, and then paste them in the column next to it. Here's what I wrote, but it doesn't work :

    Please Login or Register  to view this content.

    It crashes at the selection. Any ideas ?

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Select non contiguous range within a column

    I suggest Union, the intersect won't work like you have it here:

    Please Login or Register  to view this content.
    What your intersect selects is nothing because the 3 ranges you have indicated don't intersect at all.... the first is the whole column, but the other 2 don't intersect at all.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    12-06-2016
    Location
    Paris, France
    MS-Off Ver
    2012
    Posts
    27

    Re: Select non contiguous range within a column

    That worked Thank you very much.

+ 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] Macro to select non-contiguous union of cells based on values in other column
    By gutkinma in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-14-2014, 07:41 AM
  2. Select Non Contiguous dynamic range
    By kevinkusman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2013, 03:20 AM
  3. [SOLVED] Select contiguous range by two header names
    By capson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2013, 08:08 PM
  4. Select & copy non-contiguous range
    By SunRise in forum Excel General
    Replies: 0
    Last Post: 01-08-2013, 05:56 PM
  5. Select last contiguous range of cells in a column (seached)
    By IconoclastDX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2011, 07:59 PM
  6. Select large non-contiguous range
    By kellywa in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-23-2008, 01:11 AM
  7. How to select a range of non-contiguous rows
    By rgans in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2005, 02:54 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