Cumulative End If ?

[ZuluNation]

Hi all ! Please is it correct, if i place if then else on the same row as indicated...
and please is there a way to make the list of end if more compact or on the same raw ?
just for fun !! tx ! Paolo

Please Login or Register  to view this content.

[davesexcel]

I haven't tested your code, I believe you don't need all the else and end if's because you are using if and then on the same line.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

[Pulsus]

ZuluNation,

You can use de "ElseIf" for less End If, try this:

Please Login or Register  to view this content.

[ZuluNation]

Thank you , that works!