I think your problem is that an empty cell does not have the value o
"". Maybe test for value of 0 (zero) if you are looking for an empt
cell

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=37452