Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: how do I return a row number?
-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 -- Mcastee ----------------------------------------------------------------------- Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569 View this thread: http://www.excelforum.com/showthread.php?threadid=27430 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I return a row number?
You have it in your code
rng.row = the row with the Social Security Number -- Regards Ron de Bruin http://www.rondebruin.nl "Mcasteel" wrote in message ... -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 is searching customer records for a specific Social Security Number. Once I find the customer number, want to know what row that social security number is in so I can select the range and delete or update the 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. -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=274302 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Number | Excel Discussion (Misc queries) | |||
Return the Row number | Excel Discussion (Misc queries) | |||
VBA: how do I return a row number? | Excel Programming | |||
return row number | Excel Programming | |||
command to return the row number or cell number in excel? | Excel Programming |