+ Reply to Thread
Results 1 to 3 of 3

Select all cells in a column up to a blank cell

  1. #1
    nemadrias
    Guest

    Select all cells in a column up to a blank cell

    Hi -
    Can anyone tell me how to select all cells in a row up to (not
    including) the first blank cell in the row?

    Thanks alot!


  2. #2
    JonR
    Guest

    RE: Select all cells in a column up to a blank cell

    To go from top to bottom, it's <Ctrl><Shift><Down Arrow>
    To go from bottom to top, it's <Ctrl><Shift><Up Arrow>
    From left to right, its <Ctrl><Shift><Right Arrow>
    From right to left, <Ctrl><Shift><Left Arrow>

    If you need to select a range, you can do it in combination
    <Ctrl><Shift><Down Arrow>
    <Ctrl><Shift><Right Arrow>
    will select a block all the way down to the first empty cell, and all the
    way to the right to the first empty cell in the bottom row.

    HTH

    "nemadrias" wrote:

    > Hi -
    > Can anyone tell me how to select all cells in a row up to (not
    > including) the first blank cell in the row?
    >
    > Thanks alot!
    >
    >


  3. #3
    N10
    Guest

    Re: Select all cells in a column up to a blank cell


    "nemadrias" <[email protected]> wrote in message
    news:[email protected]...
    > Hi -
    > Can anyone tell me how to select all cells in a row up to (not
    > including) the first blank cell in the row?
    >
    > Thanks alot!
    >


    High try playing around with this in row 1

    Sub SELECTROW()
    '

    Range("A1").Select
    Range(Selection, Selection.End(xlToRight)).Select
    End Sub


    Best N10



+ Reply to Thread

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