Results 1 to 7 of 7

Selecting Non Contiguous Cell Ranges using a macro

Threaded View

capnhud Selecting Non Contiguous Cell... 06-16-2010, 02:31 PM
shg Re: Selecting Non Contiguous... 06-16-2010, 02:36 PM
capnhud Re: Selecting Non Contiguous... 06-16-2010, 02:46 PM
shg Re: Selecting Non Contiguous... 06-16-2010, 02:47 PM
capnhud Re: Selecting Non Contiguous... 06-16-2010, 02:54 PM
  1. #1
    Registered User
    Join Date
    06-04-2007
    MS-Off Ver
    Excel 2007
    Posts
    94

    Selecting Non Contiguous Cell Ranges using a macro

    I can select non contiguous cells using

    Range("c2,f2,h2").Select
    with no problem

    I can further select to the end of one column data with:

    Range("c2",  [c2].End(xlDown)).Select
    with no problem


    however when I try to put these together I using the following:

    Range("c2,f2,h2", [c2,f2,h2].End(xlDown)).Select

    I get the error:

    Run-time error '1004':
    Method 'Range' of object '_Global' failed

    I searched in vba help for what this may mean but no results found.
    Last edited by capnhud; 06-16-2010 at 03:10 PM.

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