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

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
remove caps from email

"greg" <iuouh@xxxxxxxxx> wrote in message
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?