Restrict Find to one column

Matt. · Jul 10, 2003

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 · Jul 10, 2003

Hi Matt,

Select the entire column A, then do a Find.

Chong Moua

Tom Ogilvy · Jul 10, 2003

If you mean with code

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

or

Columns(1).Find . . .

Regards,
Tom Ogilvy