ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cells.Find method and Boolean operators (https://www.excelbanter.com/excel-programming/349334-cells-find-method-boolean-operators.html)

Casey[_40_]

Cells.Find method and Boolean operators
 

Hi,
I have a small database on a worksheet (4 Columns x 6627 rows). I would
like to put a search feature on this worksheet with a Userform as the
interface. The search would only have to look at the 4th column.
I thought the code would center around the Cells.Find method, but I
can't seem to generate any code (by macro recorder), which might give
me a clue as to how I might incorporate boolean operators. I don't even
know if this is possible.
In the Object Browser I found a "FindB" member that lists it's
arguments as strings, but I can't find any more information in the help
files on FindB. Any help/guidance would be greatly appreciated.
Thanks in advance for any help.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=497442



All times are GMT +1. The time now is 02:49 PM.

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