I am new to VBA in excel. In Excel you can only have up to 7 nested if statements, I need to have more than that, how do I do this in VBA in Excel AND how do I execute the VBA code in excel afterwards? I know how to open VBA in Excel and insert a new module but from there on I need help. The code is very simple, basicly if the cell (A10) is 0 it needs to take the value of A9, but if A9 is zero it needs to take the value of A8.
Help will be apreciated.