End Sub. All the code does is to format a cell depending on the value of ActiveCell. ... VBA then executes the whole of the second Sub before returning to where it was. Add that line to ...
www.homeandlearn.org