View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Flemming Dahl[_2_] Flemming Dahl[_2_] is offline
external usenet poster
 
Posts: 18
Default Topic: Please help DrawingObjects in Cells

Hi ****al

No cell or range have such property because a drawing object is not owned by
cells.

What you gotta do is run through each drawing object in your sheet and on
the drawing object (shape) you have a property called TopLeftCell

Hope it helps you
Flemming


"rock" wrote in message
oups.com...
Hi all,

I am working on VBA. I want to highlight (work on) the cells which
contains any DrawingObject. Can you tell me such property.

Regards,
****al