>Thanks, Naomi,
>
>However could you tell me, in the following code,
>

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

>How are oRangeFound and xlValues defined?
>
>Thanks a lot,
>
>Regards,
>
>Steve

The oRangeFound is a local variable which is an object reference to a cell.
(from VBA Help
Finds specific information in a range, and returns a Range object that represents the first cell where that information is found. Returns Nothing if no match is found. Doesn’t affect the selection or the active cell.)

xlValues is defined in Excel.h and it's
#DEFINE xlValues -4163

This would be a better sample
Re: Replace Thread #1096827 Message #1101847