Hi,

Could anyone please help me with the following problem:

I want to write a macro that will find the contents of the cel
currently highlighted on another sheet. For example:

Dog
Cat
Sheep


the cell highlighted is cat, so i want to find cat on another sheet.
Another time it is sheep, so I want to find that.

I can't work out how to do this, so any help would be fantastic.

Thanks so much!

Wil

--
MrMerto
-----------------------------------------------------------------------
MrMerton's Profile: http://www.excelforum.com/member.php...fo&userid=1096
View this thread: http://www.excelforum.com/showthread.php?threadid=39866