How do I fix my Excel macro?

Hi Steven,

Thank you for your question and welcome to the forum.

When you record a macro in the front end of Excel to automate a process, the VBA application is recording each instruction you give it as a separate line of code in a procedure in a module.

If a macro is not working you will probably get an error box possibly displaying a runtime error number. If you click debug it will take you into the VBA window and display the code that was written when you recorded the macro. It will generally highlight the offending code in yellow which will need to be edited and changed.

To change the macro you have to edit the code or repeat recording the macro in the front end until you get it right.

If you want to view the VBA code then use ALT + F11. Alternatively, if you get an error number then google that error number e.g. vba error number 1004.

I hope this helps.

Regards

Simon