oRangeFound = oRange.Find("#",,xlValues,,,,,,)
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.
>
--sb--