Thanks for your help. And yes, I meant B1 = B1 -1.

I saw conflicting informaition on posts that suggested in a single line statement, consecutive stements on the same line, when separatred by ":" are treated as a statement on a new line and is not part of the If Then.

So just to confirm, as long as I am not using "else", I have a choice to use mulitple lines blocked with "endif" as the last line or I can have a single line with mulitple statments separated by ":" and no endif? Each will be treated the same?