use the Union method combined with the sample code in Excel VBA help for the
FindNext method.

--
Regards,
Tom Ogilvy


"quartz" wrote in message
...
I am using Excel 2003 with Windows XP.

I need to be able to return an array of the cell addresses of all
occurrences of a certain value in a sheet, preferably using the FIND
command.
Anyone have a clue as to how to do this? If so, could you please post an
example function or code?

Thanks much in advance.