Hi Will,

indirect returns the reference only if referenced workbook is open.

See help on indirect function for more details.

Regards,

Ivan