find function

[Av8tordude]

I'm trying to limit the range using Columns("A18:A" & LRow) , however i'm getting an error. The below code works fine, however I'm wondering is it not possible to limit the range from a specific row?

, 

SearchRange As Range
LRow as long

LRow = Range("A" & Rows.Count).End(xlUp).Row 
Set SearchRange = Columns("A:A").Find(cbName, LookIn:=xlFormulas, LookAt:=xlWhole)


If Not SearchRange Is Nothing Then
        lbName = SearchRange.Offset(0, 1)
End If

 

[dmt32]

Hi try

Set SearchRange = Range("A18:A" & LRow).Find(CbName, LookIn:=xlFormulas, LookAt:=xlWhole)

Dave

 

[Av8tordude]

Works great thank you dmt32! Cheers!

 

[dmt32]

Works great thank you dmt32! Cheers!

welcome - thanks for feedback

Dave