Avatar of Peter Chan
Peter Chan
Flag for Hong Kong

asked on 

Problem to refer to row after search

Hi,
I expect to refer to the relevant row by this
    Set c = Worksheets("Sheet1").Cells.Find("HP-SWR-013")
    If Not c Is Nothing Then
        MsgBox Worksheets("Sheet1").ActiveCell.Row
    End If

Open in new window

when there is match to the relevant string shown as above. But get this error
tt511.pngWhy?

How to go to the relevant line, when the search is finished and a match is existing there?
Visual Basic ClassicMicrosoft ExcelVBAMicrosoft AccessProgramming

Avatar of undefined
Last Comment
Norie

8/22/2022 - Mon