Is there a way to systematically change a large number of named ranges to a different workbook?
I have about 30 named ranges and I would like to change all of the named ranges to reference a different workbook. Is there a way to change all of the references at once instead of one at a time? Maybe with VBA somehow?
I have about 30 named ranges and I would like to change all of the named ranges to reference a different workbook. Is there a way to change all of the references at once instead of one at a time? Maybe with VBA somehow?
