+ Reply to Thread
Results 1 to 4 of 4

Help with Loop Start point

  1. #1
    Registered User
    Join Date
    09-09-2021
    Location
    London, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    56

    Help with Loop Start point

    Hello,
    I have some code provided me by "BadlySpelledBuoy" and I am looking for some help on how to tell the loop where to start searching the table.
    Right now my table is flush with the top and left of the worksheet Cell A1.
    The code just starts right there and does it's thing.

    I am looking for a way to tell it where to start.
    I was thinking maybe add a cell reference as a variable or something like that.

    Here is my current code that just starts at A1:

    Please Login or Register  to view this content.

    Thank you,
    Gray
    Last edited by GrayWolf; 03-11-2022 at 01:40 PM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Help with Loop Start point


    Hello,

    as an attachment may help rather than trying to foresee, with the before state worksheet and accordingly the exact expected result worksheet …

    Anyway if you really use an Excel table any reference is useless as the table has already all the necessary !
    If not in case of some range starting elsewhere than A1 - so weird ! - you can use a fixed cell reference
    and the CurrentRegion property or sometimes just using the UsedRange property of a smart enough worksheet …

  3. #3
    Registered User
    Join Date
    09-09-2021
    Location
    London, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    56

    Re: Help with Loop Start point

    Quote Originally Posted by Marc L View Post

    Hello,

    as an attachment may help rather than trying to foresee, with the before state worksheet and accordingly the exact expected result worksheet …

    Anyway if you really use an Excel table any reference is useless as the table has already all the necessary !
    If not in case of some range starting elsewhere than A1 - so weird ! - you can use a fixed cell reference
    and the CurrentRegion property or sometimes just using the UsedRange property of a smart enough worksheet …
    Hello Marc L,

    In my original message I mentioned the word "Table" however my data is not in an actual table. It is just a range of cells that look like a table, so in my error I used the word table.

    basically all this code does is:
    - pops up an input box
    - i enter a unique 3 digit code
    - code is stored
    - looks through row A for all the "Run #" column headers (there are several)
    - searches down each "Run #" column for the 3 digit code I entered
    - adds the current time into a cell a few columns to the right of the "found" 3 digit code
    - creates an audit record of the and time in column AE
    - if nothing is found sub exits
    - if the code already has a time - adds an Audit record of the code and time and places an x to show a time was already there

    I really just need a way to alter the code to start somewhere other than right at A1

    Thank you
    Gray

  4. #4
    Registered User
    Join Date
    09-09-2021
    Location
    London, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    56

    Re: Help with Loop Start point

    Found a dirty way to get it working. Thank you.

+ 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. Start new animation with same departure point as arrival point in previous slide
    By isabelle.r in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 03-21-2019, 04:01 AM
  2. [SOLVED] Start point
    By BullseyeThor in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2015, 03:19 PM
  3. Maths behind rotating rectangle around start point instead of default center point
    By Stanley91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2014, 11:01 AM
  4. Trendline start point query
    By t.jones in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-25-2013, 01:59 PM
  5. [SOLVED] Define Borders Start Point
    By nipthedog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2012, 04:15 PM
  6. Why did an inner loop variable start overwriting the outer loop range suddenly?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2012, 03:24 PM
  7. SUM using string tag as start point
    By chaz in forum Excel General
    Replies: 7
    Last Post: 10-19-2006, 05:20 AM

Tags for this Thread

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