How to delete tables with a certain string in the name?

  • Thread starter Thread starter Henrootje
  • Start date Start date
H

Henrootje

I would like to delete all tables in my database that have the string
'_Importfouten' in their name.

Any suggestions no how to do this?

TIA,

Henro
 
Dim nm as Name
for each nm in Thisworkbook.Names
if instr(1,nm.Name,"_Improtfouten",vbTextCompare) then
nm.RefersToRange.Clear
end if
Next

Perhaps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete tables with a certain string in their name? 2
table column name with newline, cannot select with string 1
Curious string error in named range automation attempt - just doesn'tseem to make sense! 5
Deleting a PivotTable. 1
How to color a row? 5
button names changed on copied sheet 4
Remove DateTimestamp from String 6
Change multple table names 6

Back
Top