VBA Multiple If Then with an Else statement

[mvparker79]

I have a list of account numbers where I need to add X days to their invoice date. I have 4 scenarios, +45 days for 1 account, +60 days for 2 accounts, +90 days for 2 accounts and +30 days for everything else. I thought I could just in put an else statement and end if but now I'm getting a compile error "next without for".

Please Login or Register  to view this content.

Could someone give me a hand on this?

[GeneralDisarray]

You need to read about including "ElseIF"

http://www.techonthenet.com/excel/formulas/if_then.php

[PCI]

Have a look on next code: NOT TESTED

Please Login or Register  to view this content.

[mvparker79]

Thanks PCI!