+ Reply to Thread
Results 1 to 7 of 7

Can't get tricky If command to function

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Can't get tricky If command to function

    Morning all,

    I wonder could anyone shed some light on my limitations: I have the following code:

    Please Login or Register  to view this content.
    The problem is activating the 5/114 variety. Is it because the name 6X0500.115 is present 2 if commands and it's choosing the first?
    It's difficult when parts share common part number. Confused

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Can't get tricky If command to function

    What exactly is the problem.

    With If statements the order shouldn't matter, the code for the one with an expression that evaluates to true should be executed.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't get tricky If command to function

    For some reason I cannot get the last piece of code, 6X0500.115(W/HUB 5/114) to activate. I'm not sure if its reading the first part which is similar to 6X0500115(W/HUB 5/112)?

  4. #4
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't get tricky If command to function

    The bottom code looks fine but I can't see why it wont fire?

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Can't get tricky If command to function

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.

  6. #6
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't get tricky If command to function

    ok, I've fixed it, I had to re-arrange the request as they were too similar.

    Thank you

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Can't get tricky If command to function

    It really shouldn't matter, when using = an exact match is needed.

    Anyway, as long as it's sorted.

+ 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] tricky if command
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-11-2016, 05:09 AM
  2. [SOLVED] Tricky IF OR AND Nested function
    By HGL in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-01-2015, 04:16 AM
  3. Help with tricky function
    By brodemeyer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2009, 05:16 PM
  4. Tricky function
    By daniello in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2007, 06:28 PM
  5. Help With A Tricky SUMPRODUCT Function
    By nevi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-31-2006, 05:55 PM
  6. Look up function-What I need to do is very tricky.
    By swestwood in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2006, 11:35 AM
  7. [SOLVED] Tricky FV function
    By MPuser in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-06-2005, 09:45 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