Results 1 to 27 of 27

For Each Statement confusion!

Threaded View

  1. #8
    Registered User
    Join Date
    08-13-2013
    Location
    CV, CA
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: For Each Statement confusion!

    Are you asking or telling me? I'm not sure I am following you. See attached file, this is what my target workbook looks like after the macro runs. You can see it stops after correctly copying over the "V" and the 7.5 on 7/18 date. But nothing gets copied over after that ....
    Quote Originally Posted by Norie View Post
    The code never goes past this point.
                If sourceInDate.Value = targetDate.Value Then    ' if match goto step 2
    It steps right to the End If every time, skipping all the code after the above line.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] confusion with IF statement
    By Mortada in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-15-2012, 05:48 PM
  2. Confusion with last row
    By LiLi1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-15-2011, 06:09 PM
  3. IF Statement Confusion
    By penny in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2007, 03:38 PM
  4. If statement confusion
    By DianeR in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2007, 07:48 AM
  5. [SOLVED] Confusion.....
    By Eric @ CMN, Evansville in forum Excel General
    Replies: 3
    Last Post: 12-27-2005, 03:20 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