M
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
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