Is there a way to copy a bunch of cells to another workbook, But also bring over the named ranges?
 

Is there a way to copy a bunch of cells to another workbook,
But also bring over the named ranges?
In the paste special, the formulas, all, etc... does not seem to do it.

thanks

Is there a way to copy a bunch of cells to another workbook, But also bring over the named ranges?
 

copy the sheet will do it

"greg" wrote in message
...
Is there a way to copy a bunch of cells to another workbook,
But also bring over the named ranges?
In the paste special, the formulas, all, etc... does not seem to do it.

thanks

Is there a way to copy a bunch of cells to another workbook, B
 

Note that if you copy the sheet the named ranges will change from being
global to being local. That can cause issues depending what you are up to...
--
HTH...

Jim Thomlinson


"Patrick Molloy" wrote:

copy the sheet will do it

"greg" wrote in message
...
Is there a way to copy a bunch of cells to another workbook,
But also bring over the named ranges?
In the paste special, the formulas, all, etc... does not seem to do it.

thanks