Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Command
I want to use the find command to find a cell that has a
specific value in the A column and the B column. I know how to use the find command to find the row with the value in the A column, but not when there is both. Thank you. Here is how I find the value in the A column With wks_W.Range("A4:A" & WorksheetFinalRow) Set n = .Find(answervalue, LookIn:=xlValues) If Not n Is Nothing Then i = n.Row End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Command
In theory... After setting N check whether N.Offset(0,1).Value = "your
value". If yes you're done, if not do a FindNext and repeat. -- Jim Rech Excel MVP "Adam" wrote in message ... |I want to use the find command to find a cell that has a | specific value in the A column and the B column. I know | how to use the find command to find the row with the | value in the A column, but not when there is both. Thank | you. | | Here is how I find the value in the A column | | | With wks_W.Range("A4:A" & WorksheetFinalRow) | Set n = .Find(answervalue, LookIn:=xlValues) | If Not n Is Nothing Then | i = n.Row | End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Command | Excel Discussion (Misc queries) | |||
FIND command | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Find Command | Excel Programming | |||
Find Command | Excel Programming |