![]() ![]() First of all, select cell A4 (it’s the cell we are going to apply the formatting and recording of our macro).To RECORD a MACRO in Excel, you can use the following steps: Steps to record a macro using the macro recorder ![]() ![]() So when you rerun this macro, it will select that particular cell to apply all the formatting on it.īut what we want is to apply the formatting on the cell, which is active (which is selected).ĭownload this macro-enabled file to follow along. The reason for this is if we select a cell while recording the macro, it will record that selection as well. Here we are going to record a macro that can make apply the following formatting to the selected cell:Īs I said, planning is essential, and before recording this macro, there’s one thing we need to take care of, and that is selecting the target cell before actually starting recording. The best way for this is to note down the steps you need to perform and then stick to it while recording. The thing is, you don’t want to get a code for the activity which you don’t want to execute while using the recorded macro again. In the same way, for recording a macro, it’s essential to do some planning. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |