Found will = Nothing if no match is made. Do a test with a known value firs

----- majikman wrote: ----

thanks for the help harald. However, it still doesn't work. I set
watch on Found and it keeps showing that its Nothing. btw, i did us
option explicit at the very top of my module so i'm not sure why i
didn't return me a type mismatch that time because it has in the past


--
Message posted from http://www.ExcelForum.com