I have a large named range that I want to save to another workbook, and I'm
trying to use the following sequence:

Range("FS_OUTPUT").Copy
Workbooks.Add
ActiveSheet.Paste
ActiveWorkbook.SaveAs ...
ActiveWorkbook.Close

I'm doing this because I don't want to affect the current workbook file
name -- I want to save the range to another file, keeping the original file
intact. All of this works except for the Range.Copy; at the Range.Copy line
I'm getting the following message:

Run-time error '1004':
Method 'Range' of object '_Global' failed

The range is a pretty large one (it spans several worksheets). I looked up
error 1004 in the Knowledge Base, and it looks like the problem might be
that there is too much data -- maybe the clipboard is getting overloaded?
One KB article said something about periodically saving the workbook during
the copy. Might that be the problem? If it is, I'm not sure how to get
around the problem except to maybe split up my named range into several
ranges, and do each one individually to the same workbook.

Has anyone else ever run into a similar problem?

Thanks,

Carl Rapson