Thread: Find Command
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam[_9_] Adam[_9_] is offline
external usenet poster
 
Posts: 15
Default 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