Add Cell range based on color of cell to existing formula

[Guest]

I'm using Excell XP 2002, Spread sheet is set up as followed

Past Due Date Total # Past Due, Past Due Date, Total # Past Due Grand
Total
12/12/2001 1 12/12/2002 3
4

I have a maco that auto insets a Past Due Date and Total, but I am so stuck
on how to add the new column of total # past due, the date columns are
colored in a yellow. Each Time I add two new columns I need to have the
grand total formula updated with the new total#past due column #,

Help, please

 

[imitk]

I'm using Excell XP 2002, Spread sheet is set up as followed

Past Due Date Total # Past Due, Past Due Date, Total # Past Due Grand
Total
12/12/2001 1 12/12/2002 3
4

I have a maco that auto insets a Past Due Date and Total, but I am so stuck
on how to add the new column of total # past due, the date columns are
colored in a yellow. Each Time I add two new columns I need to have the
grand total formula updated with the new total#past due column #,

Help, please

Jul,

Sorry I'm a little unclear as to what exactly your problem is. Could
you post the code?

 

[Guest]

Can you post the macro. the problem look like you need specific code based