Forum home » Delegate support and help forum » Microsoft Excel Training and help » How do I fix my Excel macro?
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
How do I fix my Excel macro?
Resolved · Low Priority · Version 2010
Reply Wed 16 Nov 2011, 16:48Delegate Steven said...
Steven has attended:
Excel Advanced course
How do I fix my Excel macro?
What would be the typical procedure to follow if a Macro I ran wasn't working, and noone in the office was able to fix it?
For upcoming training course dates see: Pricing & availability
RE: Macros
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
Thu 24 Nov 2011: Automatically marked as resolved.
|