Excel Theatre Blog Rotating Header Image


  1. Steve Martin says:

    I have search for a couple of days now to find a way to pause my macro. You see I have a macro that imports data into a spreadsheet, I then run this macro to clean up the data and get it in a readable format. Once that is all done then I move it to its permanent spot in the spreadsheet. Well one column of data Excel likes to format it as a time, which it is not. So I have been looking for a way to pause this macro makes my changes and then resume the macro. Well there doesn’t seem to be a way to do that, but I did come up with a solution. I run my code up to the point where I need to fix the Excel error, and at that point I open a userform, with a button on that I can click, once I have finished fixing the errors and it finishes running the rest of the code. I attached my remaining code to the button on the userform. Easy and quick.

  2. Henrik says:

    @Steve Martin have yoy tried to use “DoEvents” after the code that takes long time?