Results 1 to 11 of 11

Find first blank cell in column if rightmost cell is non blank

Threaded View

  1. #1
    Registered User
    Join Date
    01-23-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    52

    Talking Find first blank cell in column if rightmost cell is non blank

    Hello,

    I am trying to figure out how to select a blank cell if the cell next to it is a non-blank cell.

    This is the code I have so far. It just finds the first blank cell in a column.

    Sub FindBlank()
    
    Dim FindBlankCell As Range
    Set FindBlankCell = Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
    FindBlankCell.Activate
    End Sub
    So what I am looking for is if a cell in Col B is a non blank, select the first non blank in Col A in the same row.

    I will ultimately use this as a loop to paste copied data from another macro.

    Thanks for the help!
    Last edited by Mothman; 09-19-2010 at 02:11 AM. Reason: Typo on subject

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