Topic: Please help DrawingObjects in Cells
 

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

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