Error With FIND VBA

[Ark68]

I am having difficulty finding the column number based on the following VBA formula ...

nlncol = ws_data.Range("A" & dlnrow & ":HO" & dlnrow).Find(What:=entl, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False).Column

I'm getting an "Object variable or With block variable not set" error.

ws_data is recognized as the proper worksheet, dlnrow = 32. So, looking for the column number in row 32 of worksheet ws_data having the value of variable entl.

 

[RoryA]

The error means that the value wasn't found.

 

[Fluff]

I suspect that it cannot find the value of entl in row 32

 

[Ark68]

Ah ... that makes sense! Thank you!
Is there an easy way to catch this error?

 

[Fluff]

Something like

Dim Fnd As Range
Set Fnd = ws_data.Range("A" & dlnrow & ":HO" & dlnrow).Find(What:=entl, lookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False)
If Not Fnd Is Nothing Then nlncol = Fnd.column

 

[Ark68]

Thank you!!

 

[Fluff]

You're welcome