Not to be argumentative, but
the real question was

"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"

your quote referred to peripheral information -- the fact that he could be
looking at cells that contain anything. So if it looks empty, regardless
of what it contains, treat it as empty.

--
Regards,
Tom Ogilvy

"keepITcool" wrote in message
...
"Tom Ogilvy" wrote:

That assumes the cells are really empty.

THIS was the question:
"way to see if a cell has anything in it. It may be text,
number, or anything."


The time difference is
hardly significant enough to warrant "never do it again"

I said "..although it IS fractional:)"

the smiley was there for a reason...


len(trim(cells(1,1)) is more robust in situations where people clear
cells with a spacebar.

Just another opinion.

When testing for empty or 'spaced' cells, your solution
is (as always) impeccable

<vbg





keepITcool

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