Remove all define names in an Excel file
来源:互联网 发布:网络管理规范 编辑:程序博客网 时间:2024/06/02 02:51
When I copy a sheet of an Excel, promt a lot of message box about define names duplicate.
1. Open the Excel file.
2. Press "Alt + F11" (short cut) key to open Visual Basic Editor.
3. Insert a Module by right click menu, paste the following code to the editor.
Sub DeleteAllNames()
Dim nm As Name
On Error Resume Next
For Each nm In ThisWorkbook.Names
nm.Delete
Next nm
On Error GoTo 0
End Sub
4. Press F5, then click run.
5. All of the define names is removed.
- Remove all define names in an Excel file
- open an Excel file in C#
- groovy Exports all table names in database
- git remove all untracked file
- Set the number format of cells in an Excel file
- how to change file names in matlab
- Define location with sdk.dir in the local.properties file or with an ANDROID_HOME environment variab
- Simple VBScript program to extract data from all worksheets in an Excel spreadsheet
- QTP Getting data from an excel using column names
- Android的工作室 - 在项目中的所有文件名都是红色,但没有错误(Android Studio - All file names in project are red but there are
- How to define an array in c#.
- SDK location not found. Define location with sdk.dir in the local.properties file or with an ANDROID
- Error:SDK location not found. Define location with sdk.dir in the local.properties file or with an A
- > SDK location not found. Define location with sdk.dir in the local.properties file or with an ANDRO
- SDK location not found. Define location with sdk.dir in the local.properties file or with an ANDROID
- SDK location not found. Define location with sdk.dir in the local.properties file or with an ANDRO
- SDK location not found. Define location with sdk.dir in the local.properties file or with an ANDROID
- SDK location not found. Define location with sdk.dir in the local.properties file or with an ANDROID
- IE8 定义文档兼容性
- VSS的相关配置
- Stack Allocation
- 几个主要搜索引擎(Google和百度、雅虎)的站内搜索代码
- YUI Loader
- Remove all define names in an Excel file
- 如今的互联网论坛还能支撑多久
- Flex4中textField使用嵌入字体
- "_OBJC_CLASS_$_UIMainKpiXML", referenced from:错误
- Speex的学习与应用
- Java web的几种异常处理
- ★★ JAVA内存溢出解析
- 网络带宽和下载速度的换算
- 应用中的异常处理(业务异常,非业务异常)