I want to write to the status bar to assure the user that my macro is
still running and the program hasn't crashed. From the Excel help
files, I have the following:

saveStatusBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True

My question is about the saveStatusBar variable. I always use Option
Explicit in the declarations section, so I need to define this
variable, but I'm not sure what kind of variable it is. I know that
for the sake of performance, I should avoid defining it as a Variant,
so what should it be?


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=392016