如何以程式設計方式在 Excel 中複製所有的範圍名稱

Sub Copy_All_Defined_Names() ' Loop through all of the defined names in the active ' workbook. For Each x In ActiveWorkbook.Names ' Add each defined name from the active workbook to ' the target workbook ("Book2.xls" or "Book2.xlsm"). ' "x ...

support.microsoft.com