Compile error about multiline initializtion of date array

But IMHO better to put the data in a sheet :easier to change than if in code.

I couldn't agree more!

It is hard enough trying to identify a wrongly-entered date on a worksheet (where dates can be entered in a single column and sorted etc.) but it is many times harder to identify such a date within several long lines of code.

You don't need to use a loop to assign cell values to an array - you can assign values en bloc with a statement such as the following:

Please Login or Register  to view this content.

Regards,

Greg M

Originally Posted by craigvan888

... I want to init one big date array ...

The "Array" function has limitations, in this particular example there are too many lines for this function.

Thanks all!