![]() ![]() Supposing there are several range names in a workbook as below screenshot shown, now I will rename them by adding a prefix.ġ. In this article, I introduce a macro code to quickly batch rename multiple range names in Excel. To rename a range name is easy and usually used in our daily Excel work, but to batch rename multiple range names will be troublesome. XDir & Application.PathSeparator & Cells(xRow, "B").How to batch rename multiple range names in Excel? XDictionary.Item(xVal) = xDictionary.Item(xVal) + 1Ĭells(xRow, "B").Value = Mid(xVal, 1, xTemp - 1) & "-" & CStr(xDictionary.Item(xVal)) & Mid(xVal, xTemp) Note: After pasting this code, you should reference the Microsoft Scripting Runtime option in the References-VBAProject dialog box as below screenshot shown. To rename the files based on duplicate new names with name-1,name-2, the following VBA code may help you, please try it. Easy deploying in your enterprise or organization.
0 Comments
Leave a Reply. |