VBA: how do I return a row number?

[Mcasteel]

-Thanks Ron, its a great clue for me.-

Let me expand a little:

Now I want to know the row number of a given row. What Im doing i
searching customer records for a specific Social Security Number. Onc
I find the customer number, want to know what row that social securit
number is in so I can select the range and delete or update th
customer record.

Any suggestions?

_My_Code:_
Dim rng As Range

With Worksheets(1)
Set rng = .Columns(6).Find(txtCustSSN.Text)

If Not rng Is Nothing Then
'Populate frmCustLookup with Customer Information
txtLname.value = .Cells(rng.Row, 3).Value
txtFname.value = .Cells(rng.Row, 4).Value
txtMname.value = .Cells(rng.Row, 5).Value

Else: MsgBox "Customer Data Not Found"

End If

End With

End Sub


Thanks again for any advice

 

[Ron de Bruin]

You have it in your code

rng.row = the row with the Social Security Number