View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default converting a for next loop into a for each loop

Matthew,
I don't recommend you go there in this case scenario. Doing so will
require using object ref syntax, a counter, and typing more code than
what you have already.

As for your assertion that 'For...Each...Next' is more efficient than
'For...Next', I disagree: the former adds to runtime overhead more than
the latter because of the addition 'dot' processing AND required use of
a Variant or Object type for the 'Each' object<IMO.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc