Maybe this function helps you with what you are trying to do:
http://www.ozgrid.com/forum/showthread.php?t=27240

hth

Carlo

On Dec 19, 12:10 pm, LuisE wrote:
I need to perform a "Find" search in two sheets and then show the addresses
of the matches in a MsgBox. I'm running XL2000 ( No Potions in the Find
dialogbox)

I think I can create an array with the results and then show each element as
a line in the MsgBox, problem: I don't know how to do it....

Thanks in advance