Results 1 to 3 of 3

Thread: .FindNext error

Threaded View

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431

    .FindNext error

    I have this code where rngFound is a range. When I run it Excel highlights .FindNext and tells me "Method or data member not found". I've used .FindNext before without any problems. Why now?
    Code:
     
        With Sheet1       
            For lngRow = lngLastRowT To 2 Step -1
                Do
                    Set rngfound = wsWFD.Columns("E").Find(.Cells(lngRow, "E"), LookIn:=xlValues, LookAt:=xlWhole)
                    If Not rngfound Is Nothing Then
                        strFirstAddress = rngfound.Address
                        wsWFD.Cells(rngfound.Row, "A").EntireRow.Delete
                        Set rngfound = .FindNext(rngfound)
                        intCount = intCount + 1
                    End If
                Loop Until rngfound.Address = strFirstAddress
            Next
        End With

Posting Permissions

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



Click Here to Expand Forum to Full Width