Want to get macro to display progress whilst a loop is progressing the rest of the code. Tried creating a userform, but then the user form waits for me to "Close" it before processing the code and progressing to the "NEXT" in the loop. many thanks in advance for any advice