Results 1 to 3 of 3
Like Tree1Likes
  • 1 Post By Warship

Cells find in a row using vba

This is a discussion on Cells find in a row using vba within the Excel Questions forums, part of the Question Forums category; Hi, I need to find a cell based on another cell row. I tried to use this but it's not ...

  1. #1
    New Member
    Join Date
    May 2013
    Posts
    30

    Default Cells find in a row using vba

    Hi,

    I need to find a cell based on another cell row.

    I tried to use this but it's not working.

    Set aCell5 = aCell.Offset(2, 0).Select
    Set aCell3 = aCell5.Row.Find(What:=Range("bb2"), After:=ActiveCell, LookIn:=xlValues, LookAt:=
    xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
    , SearchFormat:=False)

    This is just one part of my macro.

    Thank You.

  2. #2
    Board Regular Warship's Avatar
    Join Date
    Jul 2007
    Location
    Florida
    Posts
    889

    Default Re: Cells find in a row using vba

    maybe...
    Code:
    Set aCell5 = aCell.Offset(2, 0).Select
    Set aCell3 = Rows(aCell5.Row).Find(What:=Range("bb2"), After:=ActiveCell, LookIn:=xlValues, LookAt:= _
     xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
     , SearchFormat:=False)
    Diogomg likes this.
    Regards, Warship
    Excel 2007 | 2010 on XP | Vista | 7 | 8.1

    We learn by teaching... Please complete the learning curve with feedback.

    GET LOST! Support Search & Rescue.

    Frustration is due to lack of knowledge. Lack of knowledge is due to frustration. Relax.
    Quandary: How is it that the Calendar is moving so fast when the Clock is moving so slow?


    ALWAYS USE A COPY OF YOUR FILE WHEN TESTING CODE !

  3. #3
    New Member
    Join Date
    May 2013
    Posts
    30

    Default Re: Cells find in a row using vba

    Quote Originally Posted by Warship View Post
    maybe...
    Code:
    Set aCell5 = aCell.Offset(2, 0).Select
    Set aCell3 = Rows(aCell5.Row).Find(What:=Range("bb2"), After:=ActiveCell, LookIn:=xlValues, LookAt:= _
     xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
     , SearchFormat:=False)
    It worked

    Thank You.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com