vba - What is the most efficient way of deleting a large number of named cells? -


i have 110 named cells , regularly delete using vba. way have been doing with:

namedcell_1 = ""  namedcell_2 = ""  namedcell_3 = "" 

and on..

is there faster way have process? each named cell has called name when deleting particular reasons, rows/cell numbers cannot referenced. please advise, thanks!

i did few google searches, , thought fastest way out there was:

on error resume next     each nm in activeworkbook.names         range(nm).value = ""     next nm 

but experimented around , 50% faster:

on error resume next     each nm in activeworkbook.names         range(nm).clearcontents     next nm 

both solutions leaps , bounds faster how used it


Comments