Using VBA to sum cells of a certain color

[wmatt140]

Hi,

I have been asked to sum a spreadsheet by the cells' highlighted color. I understand I can do those through VBA but have not been able to get the macro right.

If the cell range of my data is I5:S110 the the cell with the background color is A114 could some one give me the correct code?

Thank you for your help,

Wayne

[DBY]

Hello
I'm no expert with VBA but I've previously used the following code to do something similar to what you're trying to do. I've amended the code for the ranges you mention. It returns the count into cell A1. If the code is not very efficient maybe one of our forum VBA gurus can suggest an improvement.

Please Login or Register  to view this content.

Hope this helps.

[wmatt140]

DBY,

Thank you for the reply. That gave me a count of the cells with a certain color. How can I get the sum of the values in those cells?

[Paul]

I believe you can just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[wmatt140]

That did it!

Thank you all for your help.

[Richard2012]

Is there an argument you can use in CountA that will do the same thing? I've tried several ways to no avail.