Object Required error message

[Guest]

Hello people

I am trying to get the row number of a cell which is found by


Set f = Columns(3).Find(What:=ColrToFind, LookAt:=xlWhole)

and inside the if...else condition I put
Dim fRow As Double
Set fRow = f.Row

But I got a message --> Object required

Why??

Please Help

 

[Tom Morales]

Sidestepping your question, why don't you try:

Dim f As Double
f = Columns(3).Find(What:=ColrToFind, LookAt:=xlWhole).Row

Tom