Now, when you stop the recording, save the macro, and run it, Excel simply goes back to the VBA code it generated and follows the exact same steps. When you record a macro, Excel closely watches the steps you’re taking and notes it down in a language that it understands – which is VBA.Īnd since Excel is a really good note taker, it creates a very detailed code (as we will see later in this tutorial). Often, you will find people (including myself) refer to a VBA code as a macro – whether it’s generated by using a macro recorder or has been written manually. If you’re a newbie to VBA, let me first tell you what a macro is – after all, I will keep using this term in the entire tutorial.Ī macro is a code written in VBA (Visual Basic for Applications) that allows you to run a chunk of code whenever it is executed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |