+ Reply to Thread
Results 1 to 27 of 27

For Each Statement confusion!

Hybrid View

  1. #1
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    Find could be one way but there are others, eg Application.Match.

    As for the reason it does nothing after the message box that could be something to do with the data.

    Or it could be something to do with how the code is handling the data.

    Did you check what was happening (or not happening) as you stepped through the code?
    If posting code please use code tags, see here.

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

    Re: For Each Statement confusion!

    I did step through it. Very odd since it appears to be moving through all the motions and doing what I would expect with regards to the various letter codes, etc in the source data.

    That is just very odd. Why would the code stop working if it worked up to that point? I do not understand this. Its frustrating because it looks like it is behaving/working as it should .....

+ 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. [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