I have a generic find proc at
http://www.cpearson.com/excel/FindAll.aspx that will return a Range
object containing the cells in which the searched-for text was found.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]




On Wed, 5 May 2010 05:44:01 -0700, xp
wrote:

Using XL2007.

I need a reusable "generic" function that I can call and feed it three
variables:

1) a string to find
2) the column to find it in
3) whether to return the cell address of the first occurrence (top) or last
(bottom)

Can someone please help me out with this?

Thanks!