Results 1 to 4 of 4

Thread: Find end of values in a column
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2017
    Posts
    114
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Find end of values in a column

    I would like to find the first cell in a column different from the rest

    For instance column "Z" has hundreds of rows with the cell value "Fe"

    I want to select the first cell in the column different from "Fe"

    I set the range of the first instance of "Fe" as bastart and was trying this code

    Code:
    Range(bastart, bastart.End(xlDown)).Find (cell.Value <> "Fe").select
    I didnt think it would work, but something similar is what I'm looking for.

    Any help would be appreciated

    Tom

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,995
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Find end of values in a column

    Try this

    Code:
    Sub FindValue()
      Dim i As Long
      For i = 2 To Range("Z" & Rows.Count).End(xlUp).Row
        If LCase(Cells(i, "Z").Value) <> LCase("Fe") Then
          Cells(i, "Z").Select
          Exit For
        End If
      Next
    End Sub
    Regards Dante Amor

  3. #3
    Board Regular
    Join Date
    Aug 2017
    Posts
    114
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Find end of values in a column

    Dante
    I've been extremely busy with other work. I'll let you know soon if your code works for me.
    Thanks
    Tom

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,995
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Find end of values in a column

    No problem, let me know if you have any questions.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

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
  •