Five Pro Tips for Creating Excel Macros

Excel Macros can save your headaches and time by repetitive tasks, automating common, and you also don’t need to program VBA (Visual Basic Application) for it. With Excel, you can record your keystrokes and in this article, we will show you five Tips for creating Excel macros.

 Five Pro Tips for Creating Excel Macros

Here are the five tips that you need to run into your device to create Macros:

• Macro Name
• Using relative cell address
• Begin at Home
• Navigate with Directional button
• Keep Marcos specific and small

1) Macro Name

Keep names of macro small and short but descriptive, and when you re-record several macros, then you can quickly examine the micro when you have especially kept the short name. The “System” can also allow a field for properties that cannot be used by everyone.

Make sure macro names being with an alphabet and does not contain any space, punctuation mark, and symbols after First alphabets. You can also more alphabets, number, an underscore character, or here maximum length in 80 letters.

2)  Using Relative (Absolute) Cell Address

Absolute mean the approximate cell area is recorder in the macro or hardcoded and cell address like A6 or A 13. Absolute provides a limit to the macro capability to function when any change appears in the cell, such as new data removed or added, or when the list get lengthy. Relative means macro recorded relative keystrokes to find the cell location.

Here is the step on how to change relatives and stop recording:

1. Tap on the developer and then hit the macro.
2. When record macro opens, type a micro name or any shortcut key when applicable.
3. Select “Personal Macro Workbook” in the Macron Store that appears in the drop-down menu, here you need to enter properties and then tap on OK.
4. After the above process, dialog box will disappear, and the record macro option will be changed to a “Stop Recording” option.
5. Tap on the “Relative Reference” option that become dark green to show that it is active.
6. Here you need to enter keystrokes; so forth and formulas, then tap on the “Stop Recording” option and run the macro.

3) Begin at Home

Always start at home position with your cursor or data in cell A1. If you wish to save your macro into a personal workbook, then you be able to reuse that macro on a similar worksheet.

Although you need to keep your cursor positioned being with cell A1 and recording a macro, or if you have located in cell A1 already, then your first macro must be in Ctrl+Home to confidence to launch the Home.

4) Navigate with Directional Button

You can use directional keys to navigate your cursor to add delete or change data into the sheets you needed. When you have alternative spellings in the cell address, then changes and edit invalidate your function on sheet. For example: if your code as Sum A1 via A21, then you need to add more rows such as A1 to A35 here the formula not attached in the additional cell, and the total sum will go wrong.

 Here you need to use the mouse and navigate your cursor is much complicated and nit easy. When the macro appears, use your mouse to choosing or tapping on the menu option.

5) Keep Marcos Specific and Small

Keep your macro particular, and little to do your task, the bigger size of a macro run slower, primarily it is run slower, when you need to perform several functions, lots of formula and calculate in a big spreadsheet. It can combined tasks into macro or fail. To forever located in the cell to the point of failure. When you get every macro separately, then you need to review results and then verify accuracy quickly.

Emily Johnson is a creative person who has been writing blogs and articles about cybersecurity. She writes about the latest updates regarding office.com/setup and how it can improve the work experience of users. Her articles have been published in many popular e-magazines, blogs, and websites.

Source: https://legitoffice.com/blog/five-pro-tips-for-creating-excel-macros/