find an empty cell or null value
This is probably your best bet
If Trim(.Cells(iRow, 19).Value) = ""
Just in case your cell has blank spaces in it...
--
HTH...
Jim Thomlinson
"Janis" wrote:
How do you find out if a cell is null? The datatype for that field is
integer. I want to test for a empty cell. I'm not sure if either one of
these is correct.
Thanks
If .Cells(iRow, 19).Value = ""
if .Cells(iRow, 19).Value isNull
|