Hello everyone
I tried to use IIF to include four criteria in one line
I got an error at this line (Argument not optional) .. How to adapt this using IIF?Y = IIf(Ws.Name = "Sheet1", 2, IIf(Ws.Name = "Sheet2", 3, IIf(Ws.Name = "Sheet3", 4, IIf(Ws.Name = "Sheet4", 5))))
Please don't post solutions using If or Select Case ...
My issue with IIF statement ..
Is it possible to adapt IIF for mutliple criteria ..?
Bookmarks