Kamis, 17 September 2015

[ExcelVBA] ......summarise the frequency of occurence of the squares by colour down a table


also posted to MS_excel and ExcelExperts  - File in the files area

Good Evening

I have a grid of coloured cells representing planned treatments along a road, I am looking to summarise the frequency of occurence of the squares by colour along the road

I have a key of colours to refer to.....

Can this be done using Excel VBA in a manner such as described OR in a way such that the worksheet could be scanned for the colours used and a grid output on the fly? 

As you may know, I am a VBA luddite and this one has me TOTALLY stumped

Dr B

john.bullas@gmail.com [excelexpertsclub]

Show detai


Posted by: john.bullas@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar