Type mismatch error on line "num = cell.value"

....fixed the mismatch error...now getting error "object variable not
set"

Figured out its erroring a number listed on the "audit" sheet can't be
found on the "Rows" sheet so where would I implement an If-else loop?
Would need to do a check to make sure it even exists on the "Rows"
sheet.


--
mjack003
------------------------------------------------------------------------
mjack003's Profile: http://www.excelforum.com/member.php...fo&userid=5141
View this thread: http://www.excelforum.com/showthread...hreadid=468422