GoTo - where you previously were?

General rule of thumb is: don't use Goto other than in an On Error Goto line.

You should put your Formulas bit into a separate routine and just call that from the relevant section(s) in the code you posted.

Make Formulas a separate subroutine or function and just call it. You'll need to pass it the variables or set them up as Public variables.

It will do that automatically.

Hi, Another possibility is the use of the "Gosub" construct, it is functionally similar to the other solutions in that it avoids "goto" but keeps the code in the current routine so there is no issue variables scope.

Both methods will return to the statement following the "call" or "gosub"

Just an alternative approach to consider

Gosub should also be avoided in my opinion. It’s like GoTo but worse in that you’ve recognised an opportunity to refactor your code but then not done it.

You are right. Those of us who came from a green screen mainframe programming background tend to work in a top down approach and simply identify the opportunity for "sub routines" and worry about coding the actual work later. This makes the gosub an attractive option to begin with until we get more experience in functions, variable scope etc. (it is hard enough learning a new way of thinking as it is )

I don't tend to use them now as I am more comfortable with VBA

You're welcome.