Excel VBA copy all named ranges to workbook
Posted on 2013-01-07
I need to copy one workbook to another. They are set up identically, however on one specific sheet, I need to copy the data in the named ranges to the identical named ranges in the 2nd workbook sheet. (I have other data on the sheet - but do not want to copy that).
Is this possible?
Both sheets named "STAGING AREA" or Sheet12.
There are 35 identically named ranges in each sheet.
wb1 and wb2 have been declared.
Any assistance would be appreciated.