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.

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.