Avatar of Peter Chan
Peter Chan
Flag for Hong Kong

asked on 

Problem to refer to row after search

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

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

8/22/2022 - Mon