That means that there wasn't a match.

The error checking lines should have given you a beep.



trav wrote:

I can't get it to work, it is exactly what i want to do though, so thank
you, but for some reason i can't get it to work.

I first put it into my personal macro workbook, then tried in the sheet
code.

either way i can't get it to work

i get an error 2042
for this line
res = Application.Match(myCell.Value, myRng, 0)

res = error 2042

any suggestions,
i have tried renaming the sheets, no luck

i am kinda baffled.

--
trav
------------------------------------------------------------------------
trav's Profile: http://www.excelforum.com/member.php...o&userid=31420
View this thread: http://www.excelforum.com/showthread...hreadid=520341

--

Dave Peterson