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