I prefer to use:

Application.StatusBar = "Procedure Name"

Procedure Name will appear on the StatusBar which located on the
bottom of the Excel worksheet. Make this one of the first lines in
each of your Subs. I also use this with a timer and when I am using a
loop you can print the loop number so that you know where you are in
the loop.

This works like Debug.print except that it prints on one line only
and you don't need the intermediate window open.