Add Cell range based on color of cell to existing formula
 

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

Add Cell range based on color of cell to existing formula
 

On Jul 30, 8:54 am, Jul in Ohio <Jul in
wrote:
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?

Add Cell range based on color of cell to existing formula
 

Can you post the macro. the problem look like you need specific code based
on the locations of your cells. I suspectt you need to use an offset and it
will be esier to generate code if I saw the macro you are presently using.

"Jul in Ohio" wrote:

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