Marc L Excel Ninja Jul 25, 2017 #26 Mod in post #24 code : If .Length is superfluous, was just for understanding … Pointing and checking a collection is necessary for a particular element but for all elements For Each is the better way !
Mod in post #24 code : If .Length is superfluous, was just for understanding … Pointing and checking a collection is necessary for a particular element but for all elements For Each is the better way !
YasserKhalil Well-Known Member Jul 25, 2017 #27 Post #24 is very fast approach. Thanks a lot You are a legend Mr. MarcL