Sorry Jeff,

Just worked it out myself. The #VALUE Error was occurring because the named range I was using included the date row.

Thanks again.

Diana