Re: copy and paste named cells



Copy to the same workbook:
Click on the tag of the source worksheet; hold CTRL; drag the tab to the new
position

Copy to another workbook
Use Windows | View | Arrange so bat workbooks can be seen
Use the technique above

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"greg" <iuouh@xxxxxxxxx> wrote in message
news:%23jjKpeLzIHA.2220@xxxxxxxxxxxxxxxxxxxxxxx
Is there a way to copy a whole sheet.
Then paste it into a new sheet. Including the named cells and values?
in paste special? or somewhere else?
thanks



.