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?