On 13/07/2010 11:44, ManicMiner17 wrote:
Sorry this is a long post but I've been working on this forever!

I have been trying to develop a function using Find/FindNext to search
for text.


I should have said I'm trying to create a function called from a worksheet.

I found this on Chip Pearson's site:

"If you attempt to change anything, the function will terminate
immediately and return a #VALUE error to the calling cell. In Excel 97
and 2000, a UDF cannot use the Find method of a Range object, even
though that method does not change anything in Excel. This was fixed
with Excel 2002."

Looks like it got broken again in 2003!