View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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