Macro Loading Bar ??

[excel_joel]

Hey Guys,


Has anyone ever added a macro loading bar into their macros to see how much proccessing its got left to do ?
Or would it defeat the point and just take the macro even longer ?

I use a whole bunch of macro's to sort through 50,000 plus points of data, half the time I'm lead to believe my macro has crashed but I can never really know?


Are macro loading bars possible ?

[Leith Ross]

Hello excel_joel,

A solution might be possible. You should post the macro for review.

[excel_joel]

Attached is an example of one I use all the time

Please Login or Register  to view this content.

[excel_joel]

OMG No loading bar needed

Just add in

application.screenupdating = false

after dim.

Ive wasted hours wating for my macros to work, an hour processing done in a second with this little code thanks to

So this macro is working?
Speed up, add

Please Login or Register  to view this content.

after the Dim.... , will help.

[Leith Ross]

Hello excel_joel,

So, you wanted to improve the execution speed, not necessarily show the progress made. No constantly updating the screen will definitely improve the execution speed.