How does someone set the % Done on a progress bar if the answere is
always changing? Let's clarify a little bit, I need a progress bar to
act like one does for a printer. multi pages, every time its different
but always end on 100% when done.

One more question. Is it possible to add the name of the worksheet to
the caption of what the progress bar is monitoring at that time? I have
multiple mods and multiple worksheets(names). The worksheet name would
change the macro name would stay the same.


--
Information Hog
------------------------------------------------------------------------
Information Hog's Profile: http://www.excelforum.com/member.php...o&userid=21508
View this thread: http://www.excelforum.com/showthread...hreadid=397851