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 on XP

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

    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