Hi all,
I am confused about the find method, when I am in the active sheet i have no problem finding my value, but when I am trying to set the sheet then find, I run into problems. Do I need to be on the active sheet to use the find method?
Option Explicit
Private Sub Lbcrew2_Click()
Dim oscell As Range
Dim irow As Integer
Dim k As String
k = “Somevalue”
With Worksheets(2).Range(“A1:A500”)
Set oscell = Cells.Find(k, , , , , xlNextTrue)
With oscell
irow = .Row
End With
End With
End Sub
