+ Reply to Thread
Results 1 to 4 of 4

Select offset (multiple cells) up to but not including......

  1. #1
    Forum Contributor
    Join Date
    11-06-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2016
    Posts
    182

    Select offset (multiple cells) up to but not including......

    Hello -

    How would you select an offset of multiple cells up until a certain string.
    (i.e.) select the next cells in this column until you hit "group" but do nopt include the cell with "group"

    Please Login or Register  to view this content.

    Thanks

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Select offset (multiple cells) up to but not including......

    Hi, twckfa16,

    maybe use Find to set a Range to that cell and get the address from there to calculate the offset you need. The other way would be to use a Loop (maybe Do...Loop) to check the value in the cell and assign
    a value to a variable and use that
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Maybe Match could do the job as well if there is only one item to find above the starting cell.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Contributor
    Join Date
    11-06-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2016
    Posts
    182

    Re: Select offset (multiple cells) up to but not including......

    Hello -

    Was able to solve this way:

    Please Login or Register  to view this content.
    However, I am getting a type mismatch error b/c one of the cells is just an integer. I thought by converting to string, that would fix it but dod not....any thoughts?

    Thank you

  4. #4
    Forum Contributor
    Join Date
    11-06-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2016
    Posts
    182

    Re: Select offset (multiple cells) up to but not including......

    hello -

    Was able to solve this way:

    Please Login or Register  to view this content.
    Thank you

+ 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] select a range of cells with OFFSET
    By jazbath in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2013, 06:15 PM
  2. [SOLVED] How to stop OFFSET including one blank row at the bottom of the range...?
    By strud in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2013, 08:53 AM
  3. select a range of cells using .Offset
    By aloha31 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2013, 05:26 PM
  4. Select a Range of Cells Offset from a Selected Merged cell
    By kelvomatic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2013, 05:52 PM
  5. Select Cells with Data ONLY, Copy & Offset! <VBA>
    By arikoloshio in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-30-2013, 12:51 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