sum based on colour

[Sharp]

Hi,

i'm currently using some VBA code to insert a formula and sum certain rows. Which rows to sum is determined by the following line...

Please Login or Register  to view this content.

so basically, sum all rows until you get to one that has been coloured in. Is there any way to change this to say...do whilst colour index does not equal blue??...i've tried the following, but it does not work

Please Login or Register  to view this content.

here is the whole code, if that helps

Please Login or Register  to view this content.

thanks

[royUK]

Take a look at Chip Pearson's site

http://www.cpearson.com/excel/colors.aspx

[xld]

What is that code doing? I don't mean counting coloured cells, but what is the looping logic et al?

[Sharp]

thanks Roy,

in answer to your question 'XLD', it basically loops through the sheet, if 'Total' is entered into column 'B', then it will enter the sum formula in the columns specified. The sum will be above the row where total is until it hits a coloured cell...hope that makes sense

[xld]

Is it just because the colorindex for blue is not 36 but 5? That seems to work for me.

[xld]

You can also simplify the code

Please Login or Register  to view this content.