+ Reply to Thread
Results 1 to 2 of 2

Code not working correctly

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    61

    Code not working correctly

    Sorry, I don't even know how to title this correctly for searching.

    I have this macro:

    Please Login or Register  to view this content.
    It works just fine on its own, but it needs to work in tandem with this code:

    Please Login or Register  to view this content.
    and for some reason it is not recognizing the error for that macro, but it does for the other 3. I've looked it over and over and I can't figure it out. I would so appreciate some help.

  2. #2
    Registered User
    Join Date
    11-15-2011
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Code not working correctly

    Just glancing over the code, what is the reasoning behind having an ad_flg and be_flg variable? Also, once you have found one ad/be_flg = 1, there is no reason to review the remaining ones. Try using this modified function and see if it will work for you.
    Please Login or Register  to view this content.
    This eliminates all of the if statements and will escape the function if a match is found and helps the function be a little more dynamic. Hope this helps.

+ 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. vba code & formula not working correctly
    By rana19 in forum Excel General
    Replies: 0
    Last Post: 11-22-2014, 09:51 AM
  2. Replies: 9
    Last Post: 03-08-2013, 11:50 AM
  3. Save As Code Not working correctly
    By EOAEvan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2007, 02:05 PM
  4. Advanced filter code not working correctly
    By dcwat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2007, 09:25 AM
  5. VBA not working correctly
    By HuskerBronco in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-28-2006, 03:15 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