* The first time
oRangeFound = oRange.Find("#",,xlValues,,,,,,)
* Subsequent
oRangeFound = oRange.Find("#",oRangeFound,xlValues,,,,,,)

Check Excel VBA help for other parameters to Find() method.

>
>Thanks a lot. I have tested this and it works. The next bit is using the FIND through automation to find such cells within the UsedRange. I hope I am not asking for too much. The power of knowledge is gauged by how far it has spread.
>