well anyway it copied that one name cause there was a formula that contained
a reference to that named range.

"ben" wrote:

I have a macro that copies a named range of data and pastes it to a blank
workbook. the copied data has merged cells that naturaully merges the blank
workbook cells appropriately once pasted. The original data has MANY named
ranges. I do not want any named ranges to transfer with the copy & paste,
however once specific name copies over and ONLY ONE. I can not figure out why
this one named reference transfers while the rest do not. Any suggestions as
to why this does so?
--
When you lose your mind, you free your life.