Catherine Wrote:
What is the Status Bar used for?

It's often useful for monitoring progress when performing a length
operation or looping.

For example:

For I = 1 to 20000
Application.Statusbar= "Looking at row " & I
...
...
Next I

I think I'm right in saying that it updates even when you hav
screenupdating turned off which makes it extremely usefu

--
ronthedo
-----------------------------------------------------------------------
ronthedog's Profile: http://www.excelforum.com/member.php...fo&userid=2650
View this thread: http://www.excelforum.com/showthread.php?threadid=39811