What I really mean is to LINK an entire named range from one worksheet to
another worksheet within the same workbook. I don't want to link (or copy)
the entire worksheet just link the range.

Sorry for the incorrect terminology and for not being very clear the first
time. I'm not used to using this help feature.

Also, thank you for your quick response.

"Bernard Liengme" wrote:

Do you really mean COPY ? If so just copy and paste
If you want Sheet2 to show the same values as in Sheet1, use =Sheet1!A1

Please, a workbook is made up of WORKSHEETS, the tab is the thing that opens
a worksheet
If you use incorrect terminology you will find it hard to use Help

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RJF" wrote in message
...
Is there a function in Excel that lets you copy and entire range from one
tab
to another?

Thank you.

Rachel