copy the range names while coping cells
 

i need to copy an area from one workbook to another. that area in cludes
cells that have range names.i need a way to copy the range names as well. not
only the formating and the data.
do you know how i could do that?
--
Miri Tz.

copy the range names while coping cells
 

Be careful when you copy named ranges to a new workbook. They do copy over
but they act differently depending on whether it is a sheet level or workbook
level name. You will need to check their references once copied.

"Miri" wrote:

i need to copy an area from one workbook to another. that area in cludes
cells that have range names.i need a way to copy the range names as well. not
only the formating and the data.
do you know how i could do that?
--
Miri Tz.