• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count the number of cells with specific colors

MaulaJatt

New Member
Hi Guys,

I am new to the excel vba and was wondering if any can help me with how can I accomplish the following. I am a financial modeler some time I use the color codes to define certain categories with in the data, I was if someone can help me define a VBA code to sum no of cells with specific color with in the range. or count certain number of cells in the range with specific colors.
 
Hi, just filter on color then use the SUBTOTAL worksheet function to count or sum the visible cells as explained in Excel help.​
If really a VBA code is needed, activate the Macro Recorder and operate manually in order to get your own code base …​
 
Back
Top