+ Reply to Thread
Results 1 to 2 of 2

Keeping track of element position in for each...loop?

  1. #1
    Forum Contributor Rhudi's Avatar
    Join Date
    03-08-2013
    Location
    South Carolina, US
    MS-Off Ver
    Professional Plus 2016 aka Office 365
    Posts
    199

    Keeping track of element position in for each...loop?

    I'm not sure the correct way to ask this..

    If I do this:
    Please Login or Register  to view this content.
    How do I keep track of how far I am in the array?

    I could always do this:
    Please Login or Register  to view this content.
    So, obviously, in the second example, "x" marks the spot. Is there a property of the control variable in the "For Each..." method that I can use to be sure how far I am?

  2. #2
    Forum Contributor Rhudi's Avatar
    Join Date
    03-08-2013
    Location
    South Carolina, US
    MS-Off Ver
    Professional Plus 2016 aka Office 365
    Posts
    199

    Re: Keeping track of element position in for each...loop?

    NVM. I just read this:
    https://support.microsoft.com/en-us/kb/129931

    From that page:
    Although it is possible to use For Each on an array, there is rarely a reason to do so. You pay a substantial performance penalty on For Each statements.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. element position problem (from 2003 to 2010)
    By kensei in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 01-19-2011, 03:58 AM
  2. keeping track of possible solutions?
    By oks10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2010, 05:44 PM
  3. Keeping Track Of Holidays
    By JamesT1 in forum Excel General
    Replies: 1
    Last Post: 08-30-2008, 05:45 AM
  4. Keeping track
    By JamesT1 in forum Excel General
    Replies: 2
    Last Post: 08-23-2008, 08:03 AM
  5. Replies: 1
    Last Post: 08-03-2007, 05:08 AM
  6. Keeping track of changes and saves
    By mattflow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2006, 04:50 PM
  7. keeping track of time
    By jhahes in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2005, 10:05 PM
  8. [SOLVED] Keeping track of useful macros
    By malvis in forum Excel General
    Replies: 1
    Last Post: 08-02-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1