Hi Michael
you may wrap your code in the following statements to prevent the
flickering

-----
Sub foo()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
'...
'enter your code
'...
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic
end sub
-----


--
Regards
Frank Kabel
Frankfurt, Germany

Michael wrote:
Ok I know this one is probably simple.

How can I make the screen show something other than all the flicker
as a macro executes. I would like to do something like a logo or
Please Wait. But a blank would be fine.

I would like to add it to the begining of my code and turn it off at
the end.