Update Holiday in advance

[Djimmy]

Hi,
I have automated macro and run periodically. I would like to have a piece code to add my macro, and update my holiday table before next run. Meaning when I run today (June 6, 2010) the macro will populate my table and add the coming holiday ei: July 4, 2010.

Here is table I have:
11/26/2009
11/27/2009
12/25/2009
1/1/2010
1/15/2010
2/15/2010
5/31/2010
Populate here next holiday ( this case July 4, 2010)

Please let me know the possibilities..

Thanks.

Jimmy

[shg]

Why not just manually add all the holidays for the next five years or so and be done with it?

[Djimmy]

Thats correct..But the excel file i have is left only one cell ..Meaning the next run will be:
11/27/2009
12/25/2009
1/1/2010
1/15/2010
2/15/2010
5/31/2010
7/4/2010
???? Next holiday ( this spot is availbale always)...

Thanks

[shg]

But the excel file i have is left only one cell ..

Pardon ?