How do Count how many shapes are on a sheet?

Dear Jamil,

Thank you again for your answer and help.

We thought we were using also original shapes.

1) How could we assign a shape name to each different one?

2) Which are the "original Excel built-in shapes"?

Tx, Juan

Hi,

I can see that you are only using images. not the original Excel built-in shapes.
However, it is possible to count the specific images, but they need to be named properly.

for example these two images have the same name Gráfico 373 & Gráfico 375  if you want them to be counted seperately then you need to name each type differently, regardless of it is number, but the Gráfico to be replaced with something else. similarly for other image objects as well. each of them should have a unique name

for example this one bulb 1 and bulb 2 for the second image like this and then bulb 3 for third and so on.  so the bulb name should only be used for this image.

Dear friend,

I hope you are fine. we have reviewed the excel to assign shapes to all items we would like to count instead of mixing images and shapes. Even though some of them are still marked with an image. The image will serve to guide us from a visual point of view. However the shapes can give us an idea of how many items will have to count.

It would be fantastic if we could make a macro that counts the items per floor. We have tried to do the  plans separated so that the surface could be the limited for each floor.

In columns K and L you have the shapes that we would like to count.  

Please feel free to send us any suggestion that could facilitate the macro to be made. Also if you just make an example for the first floor, we could copy it for the following floor just changing the area to be counted.

Thank you very much in advance, Juan