I've always used "if(len(cells(i,j))=0"

Stan

"mike allen" wrote in message
...
I have haggled w/ this forever it seems. I want a universal (old and new
excel versions) way to see if a cell has anything in it. It may be text,
number, or anything.
in excel2000, ...if cells(i,j) < 0 then... worked, but it didn't
work
in an earlier version (I think 97).
...if application.isempty(cells(i,j)) then... doesn't work, but ...if
isempty(cells(i,j)) then... works in 2000. This is interesting b/c I
have
come across instances where putting 'application' in front of a command
allows it to work in 97, while it worked either way in 2000.

If I don't see anything in the cell, I expect it to detect this empty
field
and skip over it, regardless of what version of excel the user has and
regardless of whether I am looking for text or numbers or anything else.
Is
there a sure-fire way to accomplish this? thanks, mike allen