Macro

[atuljadhav]

Sir

If i create simple macro, for example insert row, delete column, formatting data etc. and save, but when i run this macro it done in second,
i want to display macro very slow which can user understand the steps which i have recorded in macro, is there any option that macro run very slowly or step by step by clicking mouse???

 

[Joe4]

One way is they can "Step" through the code one line at a time to see what it is doing. I do this when trying to debug code.

What I typically do is open the VB Editor, and re-size it down to about one-quarter the size of the screen so you can see both your worksheets and code at the same time. Then, highlight the first line of your macro. Then press F8. Each time you press F8, it will process one line of code and you can see what it is doing to your sheet in the background.