You can check if a cell is empty with

for each cell in Range("A1:A10")
if isempty(cell) then
' cell is empty
else
' cell is not empty
end if
Next

--
Regards,
Tom Ogilvy

"empty cell" <empty wrote in message
...
I have a program I made for points which I used (if and) format, which I
will
enter a different number each time, where the empty cell I don't want to
be
considered as zero

thank you