Restrict Find to one column

[Matt.]

Hi all!

I did a quick Google search but couldn't find the answer to the question:
How do I force Excel's Find to only search column A?

Any help greatly appreciated.

cheers,
Matt.

 

[Chong Moua]

Hi Matt,

Select the entire column A, then do a Find.

Chong Moua

 

[Tom Ogilvy]

If you mean with code

Range("A1").EntireColumn.find . . .

or

Columns(1).Find . . .

Regards,
Tom Ogilvy