IF statment nested within VBA Code

[Paul_Hossler]

Try this

I went back to my prefered way to show all rows and then hide the ones I don't want based on Mode, Lane and Loading since otherwise the show/hide/show, ... gets complicated and I can't keep the logic straight

That way therre's no need for lots of "Range("A22:A25").EntireRow.Hidden = False" through out since all rows show to start with and only the N/A ones based on Mode, Lane, and Loading need to be hidden

I think the logic is complicated enough so I'm trying to keep it simple

I marked adds / changes with <<<<<<<<<<<<<<<<<

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

There's no logic for Factory Load in the macro. Is there supposed to be?