+ Reply to Thread
Results 1 to 5 of 5

Select Range

  1. 08-16-2016, 10:05 AM #1
    scrabtree23 is offline
    Forum Contributor
    Join Date
    07-27-2012
    Location
    Somerset, Kentucky
    MS-Off Ver
    Excel 2007
    Posts
    123

    Select Range

    I have a cell named "StartCell" and one named "EndCell".

    I want to select a range from StartCell to EndCell.Offset(-1,0). Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 08-16-2016, 10:24 AM #2
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Select Range

    Maybe :

    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  3. 08-16-2016, 10:27 AM #3
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Select Range

    Hi,

    My interpretation is a little different to Karedog's

    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  4. 08-16-2016, 10:29 AM #4
    scrabtree23 is offline
    Forum Contributor
    Join Date
    07-27-2012
    Location
    Somerset, Kentucky
    MS-Off Ver
    Excel 2007
    Posts
    123

    Re: Select Range

    The second line produced an error?
    Reply With QuoteRegister To Reply
  5. 08-16-2016, 10:30 AM #5
    scrabtree23 is offline
    Forum Contributor
    Join Date
    07-27-2012
    Location
    Somerset, Kentucky
    MS-Off Ver
    Excel 2007
    Posts
    123

    Re: Select Range

    xlnitwit...that worked. Thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make 'ActiveSheet.Range("C5:N100").Select' - select a dynamic range of cells
    By white_ross in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-13-2016, 10:00 AM
  2. Select range using .End(xldown).Row.select
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2015, 07:12 AM
  3. .select method with worksheets object ex. Sheets("Sheet1").range.select fail
    By RobCan in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-19-2014, 07:01 PM
  4. Newbie: Auto Select/un-Select an Range of Slicer Items
    By luckyali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 09:52 AM
  5. Look up cell, use as reference to select from a range, to then select data in a column...
    By transportplanner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-17-2013, 05:21 AM
  6. send to range, popup box to input what the range should be each time/select range
    By lax2734 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2012, 01:37 AM
  7. Code to select range and open a user form is opening the wrong range
    By rrbest in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2010, 12:34 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1