ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Restrict Find to one column (https://www.excelbanter.com/excel-programming/271314-restrict-find-one-column.html)

Matt.

Restrict Find to one column
 
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

Restrict Find to one column
 
Hi Matt,

Select the entire column A, then do a Find.

Chong Moua
-----Original Message-----
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.


.


Tom Ogilvy

Restrict Find to one column
 
If you mean with code

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

or

Columns(1).Find . . .

Regards,
Tom Ogilvy


"Matt." wrote in message
.. .
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.






All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com