LinkBack URL
About LinkBacks
i m trying to scan thru the namemanager via vba macros and delete all tables with prefix "import" but i keep getting error sub or function not defined on dlookup
Please Login or Register to view this content.
i m trying to scan thru the namemanager via vba macros and delete all tables with prefix "import" but i keep getting error sub or function not defined on dlookup
Please Login or Register to view this content.
Last edited by littleangel; 09-05-2023 at 12:58 AM.
If you are talking about Structured Tables, you can't delete the references in Name Manager. Those references are created when you insert a Table, and subsequently managed by Excel.
Not really a case of what the names start with.
You'd have to delete the table or convert the table back to a normal range.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Obviously the initial post code was not made under Excel ‼ Or wrong forum section ?
The reason why copying / pasting can't be obviously coding …
the code was for a function i changed it for macros ,instead of sub if its function it gives no error but when its changed to sub it gives error....plz note..i m still a noob in vba and leaning from google
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
What are you trying to delete? The Reference to a Structure Table in Name Manager? The actual Structured Table? Or something else? Maybe something in Access?
Re: unable to delete table with certain prefix via vba
Originally Posted by littleangel
Again : here it's an Excel VBA forum but your code is obviously very not an Excel VBA code ‼
this code worked to delete name containing "import" from name manager
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks