| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I delete ExternalRata range names?
Whenever I run a web query it inserts a new ExternalData name into the
name box. So it keeps going ExternalData1, ExternalData2 and so on. 1. How can I stop that? 2. How can I manually delete those names? Nothing seems to be able to get at them. Thanks, Nathan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete ExternalRata range names?
Try this.
Sub DeleteWorkbookNames() '' Deletes extraneous names left from queries. Dim Nim As Name For Each Nim In ActiveWorkbook.Names If Nim.Name Like "*ExternalData*" Then Nim.Delete Next Nim End Sub HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- Whenever I run a web query it inserts a new ExternalData name into the name box. So it keeps going ExternalData1, ExternalData2 and so on. 1. How can I stop that? 2. How can I manually delete those names? Nothing seems to be able to get at them. Thanks, Nathan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I delete ExternalRata range names?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete multiple range names | Excel Discussion (Misc queries) | |||
| How to Delete blanks between a range and populate only the names inthe given range | Excel Discussion (Misc queries) | |||
| How to delete a hundred range names at once? | Excel Discussion (Misc queries) | |||
| How to delete a hundred range names at once? | Excel Worksheet Functions | |||
| not delete worksheets from names in a range | Excel Discussion (Misc queries) | |||
Linear Mode
