copy a sheet not all the range names in a workbook

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

Hi All

this is driving me crazy - i want to use "move or copy sheet" to copy a
particular sheet to another workbook but i do not want all the range names
in the whole workbook coming across (i seem to be spending a good part of
the day deleting them ... one at a time!!!) ... any check boxes anywhere
that i've missed? or is there another option.

Cheers
JulieD
 
Hi Julie

Copy all the cells to a new sheet in the other workbook

Ctrl-A (twice in 2003)
Ctrl-C
Paste it in a empty sheet in the other workbook
 
Hi Ron

thanks - i was hoping to avoid having to use that method :) but i guess i'm
going to have to if there's no checkbox anywhere about not copying range
names (i wouldn't mind if it copied the range names in the sheet ... but to
take all of them!!!).

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Excel Move or Copy Stopped Working? 0
HELP - A formula or sheet you want to move or copy contains the name .... 0
Copy worksheet containing names to other workbook w/o problems? 1
Start sheet in a workbook 2
Define Name range 10
Copying Sheets between workbooks without links 3
Copy sheet to different workbook 1

Back
Top