Integer variables can only have integers values, not Null ir blanks. You
can set the variable to 0 and clear contents on the cell to which it
would otherwise be assigned. Or you could use a Variant and assign
vbNullString.


--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30494