Object Required error message

Mar 4th, 2002, 10:28 AM

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 · Mar 4th, 2002, 12:32 PM

Sidestepping your question, why don't you try:

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

Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 10:28 AM	#1
Guest Posts: n/a	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

Mar 4th, 2002, 12:32 PM	#2
Tom Morales Board Regular Join Date: Feb 2002 Location: Richland, Washington Posts: 91	Sidestepping your question, why don't you try: Dim f As Double f = Columns(3).Find(What:=ColrToFind, LookAt:=xlWhole).Row Tom