What if your spreadsheet could do that for you? With a macro, it could. Now, let’s get started with actual coding!Ĭopying and pasting is the simplest way to move data around, but it's still tedious. When you’re done, go to the 'View' tab, click the tiny arrow below the 'Record Macro' button again and select 'Stop recording'. Perform the actions in your spreadsheet you want to be turned into a macro. Type in the name of your macro and click 'OK' to start the recording. Go to the 'View' tab of the ribbon and click the tiny arrow below the 'Macros' button. But it's still a handy way to get started. You'll still need to type or edit code manually sometimes. There are limitations to this, so you can't automate every task or become an expert in automation by only recording. When you’re done, tell Excel to stop recording and you can use this new macro to repeat the actions you just performed again and again. Then you perform the tasks you want to be translated into VBA code. When you record a macro, you tell Excel to start the recording. Later on, it serves as handy storage for code that you don’t need to memorize. Recording a macro is a good way of getting to know the basics of VBA. The main focus of this article is on the former, but recording a macro is so simple and handy, it's worth exploring too. There are two ways to make a macro: code it or record it.
