View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default finding empty selection

if application.counta(selection) = 0 then

would be a start. Cells can't contain charts, so I don't see that as an
issue.

--
Regards,
Tom Ogilvy


"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