Forum Discussion
How do Count how many shapes are on a sheet?
I looked at your file and if you have used the built-in Excel shapes or at least your objects were drawings and not picture, then what you have asked was easy.
Now, the complication starts when your objects are not drawing/shapes but they are picture objects and hence we cannot identify them by object type based on how it looks.
If you are willing to work with non-picture objects, then I can write some function that can count based on each room next to the each icon.
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