for some reason i am only adding 1 day at a time and the range i put in B43 is 6/12/2012
to basically trigger the scenorio do your job part since it is over 30 days
plus if just before i end sub I make the value of B43 become todaysdate, in my mind it will get thru all the errors and run the calculations first then change the value of B43 correct
plus in Excel 2003 is there a way to insert a command button to run the macro, or do i have to Alt-f8 run it all the time?
I just want to see what i am coming up with in the values of DaysNumber, EnteredDate, TodaysDate
for troubleshooting.
this is code that came from the generosity of Pichingualas
thanks for the help
daluv
Bookmarks