- Aug 5, 2002
I have one workbook with a bunch of named ranges. I want to consolidate this into another workbook. When I copy the sheet with the named ranges onto a newly created worksheet in the larger workbook, the named ranges don't copy over. How do I do this?