"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