Macro which sums up equally colored cells

[Marina86]

Dear forum residents,

I am completely new to VBA, and now I have to write a macro which finds equally colored cells (into which random numbers are inserted), sums them up (each color separately) and expresses the results into the column specified in the same particular sheet, sum of each color into particular cell. The only condition is that although I made 7x7 table of color cells (for the comfort), the area where the program searches for color cells has actually no limits (on this sheet). I just started to learn VBA and I have only 3 days to solve this issue. Therefore could anyone please direct me to the textbook chapter, topic or tutorial where I could learn the commands necessary to complete this task, or give an advice where to start. Since I am not the programmer, I am completely lost (but Id like to learn!)

best regards

[David A Coop]

I can't really point you to any particular reference, as I am pretty much self taught from sites like this, but I have attached a small macro which might give you a clue.

Hope this helps.


excel001 SUMFMT example.xlsm

[BS Singh]

Hi Marina,

Hope code below will work for given task

Please Login or Register  to view this content.

Regards,
BS

[venkatpvc]

Please Login or Register  to view this content.