Results 1 to 20 of 72

Thread: IF statment nested within VBA Code

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #38
    VBAX Regular
    Joined
    Sep 2023
    Posts
    77
    Location
    Well that's weird then, I've attached the workbook again so you can see what I'm getting/seeing.

    Everything works OK with the exception of the rLoading, the incorrect rows are not being hidden/unhidden when rloading matches 'CFS Loading', nothing happens when changing rLoading between 'CFS Loading' & 'Factory Load'

    If I select 'Ocean_EU_to_US for rMode and 'Gdynia to New York' for rLane, then when rLoading = 'CFS Loading then Row C19 should be hidden and row 20 should be visible

    Same for Gdynia to Los Angeles
    Hamburg to New York
    Hamburg to Los Angeles

    This is because there are different collection points required depending on CFS or Factory selection in rLoading
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •