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
Post a Comment