Why don't you just use a dynamic range for the holidays list?

--
Biff
Microsoft Excel MVP


"penGuin_1" wrote in message
...
Hello,

I would appreciate your help with:

Trying to create an automated process whe

A is Date; B is days; C returns date (where referenced to constant array)

Array would consist of 9 holidays, but I would like to include up to 25
place holders in order to activate on main worksheet with checkbox to turn
"on"

Like this:

A B
Holiday; 1/1/09
Holiday; 2/16/09
Holiday; 5/25/09
etc (total of 9)
Reserved 1; empty
Reserved 2; empty
Reserved 3; empty
Reserved 4; empty
etc (up to 25 reserved)

I appreciate your help.

Thanks
--
- thank you
penGuin_1