use:
not isempty(Range("a1"))
or
Range("a1")<""

..value is optional as it's the default property of the range


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"mike allen" wrote:

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