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:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___

Tidak ada komentar:

Poskan Komentar