Steph,

Yes, as long as they are the same cells on each worksheet: Sheets 1 to
Sheet 2 cell A1 is OK, Sheet1 cell A1 and sheet2 cell B2 is not OK.

HTH,
Bernie
MS Excel MVP

"Steph" wrote in message
...
Can a single named range include cells from multiple sheets?