sum by cell color but cannot identify the cell range

[isay]

Hello there!

I have 5 set of data in excel with the same color identification. I want to sum the value per color in each set of data.

I tried to do some research but the code specify the range of the cell where to sum. With my case, I cannot identify what range of the cell. My program will just fill on the worksheet all the available data that can be retrieve from my source. So I dont know what particular range it will fill.

Please help me with the code on this.
Thank in advance

 

[isay]

or intead......

with the code on how to identify the range of the cell according to its cell color per column and row.

Thanks in advance

 

[PaddyD]

"...With my case, I cannot identify what range of the cell..."

Makes the task a little difficult!

As well as the general description, post back with a detailed example of what you're trying to do etc.

 

[isay]

Book1.xls
	A	B	C	D	E	F	G
4		Account				Total
5	A	420722	$ 2,736,177.83	$ 63,637.66	$ 2,799,815.49	Sum of Blue in D col	Sum of Blue in E Col
6		420723	$ 131,839.13	$ 4,222.34	$ 136,061.47	so on..
7		420724	$ 59,691,864.64	$ 3,504,745.22	$ 63,196,609.86
8		440010	$ -	$ (2,853,793.50)	$ (2,853,793.50)
9		440017	$ (33,288,119.24)	$ -	$ (33,288,119.24)
10		441110	$ (1,742.29)	$ 938.81	$ (803.48)
11		441120	$ (70.72)	$ 11.22	$ (59.50)
12		448920	$ 7,202.78	$ -	$ 7,202.78
13		461210	$ 492,882.60	$ 7,242.65	$ 500,125.25
14		758143	$ 2,110,043.85	$ 44,386.34	$ 2,154,430.19
15		758153	$ 461,875.15	$ 4,500.00	$ 466,375.15
16
17						Total
18		421101	$ (2,690,235.81)	$ -	$ (2,690,235.81)
19		421102	$ 1,691,853.64	$ -	$ 1,691,853.64
20		421103	$ 475,364.14	$ -	$ 475,364.14
21		421104	$ 2,719.00	$ -	$ 2,719.00
22		421108	$ 35,934.26	$ -	$ 35,934.26
23		421111	$ (10,090,513.90)	$ -	$ (10,090,513.90)
24		421112	$ 3,252,410.63	$ -	$ 3,252,410.63
25		421113	$ 2,904,222.03	$ -	$ 2,904,222.03
26		440017	$ (5,503,508.15)	$ -	$ (5,503,508.15)
27		441330	$ (10,446,053.95)	$ -	$ (10,446,053.95)
28		758041	$ 720,305.30	$ -	$ 720,305.30
29		758042	$ 532,855.57	$ -	$ 532,855.57
Sheet1

Hi, see my sample above msg.

I have that format in my worksheet. When I run my program, those information from ColB to ColE are inputted in my worksheet but not all of the accounts are always available from my source file. That is why, in ColF and ColG, I cannot identify the range of the colors that I want to sum because the data is upon its availability. I need your expertise for the code on this one.

Please post back if I didn't make myself clear again.

thanks so much..