Anno, You're correct, I wanted to copy the named range to another worksheet in the same workbook. But what is it called when there is a reference to the worksheet and a range? Like 'Sheet1'!$C$3:$h$5 ... I know at work I've seen references like this on maybe sheet 2, bringing that data over from sheet 1. Thanks again for your help, Dave