Agreed Tom, I was building on your example to show another method albeit for
Cell (singular without the s).

IsNull was a nonsense suggestion I agree !
--
Cheers
Nigel



"Tom Ogilvy" wrote in message
...
Just some added information:

IsNull has no play in this situation that I can see.

IsEmpty is only pertinent to a single cell (selection can be multiple
cells
and the OP does say cells with an s) - So a loop might be required to
use
IsEmpty

--
Regards,
Tom Ogilvy

"Nigel" wrote in message
...
Take a look at IsEmpty or IsNull as a way to determine presence of
content
in a Cell e.g.

If IsEmpty(Range("A1")) then MsgBox "A1 is Empty"

--
Cheers
Nigel



"Chimanrao" wrote in message
oups.com...
how do I find out if the selected cells have no content ie. no text,
charts, links etc?

Chimanro