Results 1 to 5 of 5

If statement won't recognize two values as equal

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    If statement won't recognize two values as equal

    Hi all,

    I've included a detailed screen shot with some notes on it, I would encourage taking a look at that.
    The issue I'm having is that a loop statement of mine is failing to recognize that a couple values are equal. It works for the first 3 iterations of the loop, then stops recognizing. I tried copying another set of numbers in the failing one's place, and that actually worked.
    Not sure how else to explain it, but if you take a look at the screen shot you can see the excel sheet being worked on and the vba code running. I will also include a text file of the code for anyone who would like to change the code to offer a suggestion.

    Thank you!
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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