How to Examine & Edit the VBA Code for a Recorded Macro
Learn how easy it is to edit the VBA (Visual Basic for Applications) Code for a Recorded Excel Macro. The is the 3rd segment in my series, "How to Record, Run, and Edit a Macro in Excel."
In this tutorial, I demonstrate how to:
1) Open up the VBA Code for the Macro.
2) Step Into each line of the code using the F8 Keyboard Shortcut.
3) Use an Apostrophe (') to "remark out" a line of code. (This will convert the Macro from using Absolute Cell Referencing to one that uses Relative Cell Referencing).
4) Change the text that the Macro enters into a cell.
I invite you to visit my secure online shopping site - http://shop.thecompanyrocks.com - to see the range of video training materials that I offer.
Danny Rocks
The Company Rocks