I am using excel 2003 to look at process flow. As part of this I am using excel’s flow chart shapes to diagram this flow. Some of the processes are quite extensive and there are multiple shapes which are placed onto our spreadsheets. What we need to be able to do is to count the total number of the shapes as well as to count certain shapes with certain characteristics, e.g. counting the flow chart process shapes that are colored yellow or counting the flow chart decision shapes colored aqua. Is there any function which can accomplish this or vba? Also some of these stock shapes may need to be altered by grouping other shapes with them and these may need to be counted. This all needs to be reported back to a cell e.g. A1. Any ideas? Thanks upfront for you assistance.

Sincerely,

Trace

Sincerely,

Trace

Last edited: