Look at Find in VBA Help.

--
__________________________________
HTH

Bob

"Robin" wrote in message
...
hello

i need help creating a macro that reads values from one sheet and
high-lights all the rows where the values appear in another sheet.

I have no idea on how i go about doing this, plz help!