| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting a for next loop into a for each loop
On May 3, 11:53*am, GS wrote:
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 athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc Thanks for the help Garry. Glad to know i'm not crazy. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning back to loop check condition without completing the loop | Excel Programming | |||
| Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
| Naming Worksheets - Loop within a loop issue | Excel Programming | |||
| (Complex) Loop within loop to create worksheets | Excel Programming | |||
| Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Threaded Mode
