I have no code to input here. I'm looking for alternative ways and probably way outside the box ideas on how to count a shape in a given excel range (A2:10) wihtout using the .topleftcell property. I know that's how excel counts them I'm just wondering if there is potentially some method of achieving this with a .top >0 type of code. I've been playing with it so far I've been able to get a count of all shapes using the .top >0 value ,but I don't know if it's possible to restrict that to a range.
Any help is much apperciated, and it's possible this is all just a wild dream.
Regards
G
See threads below that so some of the coding, I'm placing an edit at the front before labeling solved. Does anyone know how to take that code and do a -1 for each bar of a certain color?
Bookmarks