I have a spreadsheet with person-names in Col A. The user may freely create
ranges to show different combinations of users and the ranges exists only as
Named Ranges.

Once i a while I'll have to copy the person-names and range names to a new
workbook (a new period of time).

Could anyone please tell me how to transfer all existing ranges from one
workbook to another using VBA or which approach to use?

Thanks in advance