copy a sheet not all the range names in a workbook

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
 
R

Ron de Bruin

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
 
J

JulieD

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
 
Top