04-12-2020 , 06:01 PM
Quote:Get the most out of this powerful Excel feature with some simple rules that will make recording and using macros a cinch.
Excel macros save you time and headaches by automating common, repetitive tasks, and you don’t have to be a programmer or know Visual Basic Applications (VBA) to write one. With Excel, it’s as simple as recording your keystrokes. Use these tips to make macro recording a cinch.
1. Macro names:
Keep macro names short (but descriptive), especially if you record a lot of macros, so you can easily identify them in the Macro Dialog Box. The system also provides a field for Description, though not everyone uses it.
Macro names must begin with a letter and cannot contain spaces, symbols, or punctuation marks. After the first letter, you can use more letters, numbers, or the underscore character, but the maximum length is 80 characters.
2. Use relative (not absolute) cell addresses:
Absolute means that the exact cell locations are recorded into the macro—hardcoded cell addresses such as A6 or B12. Absolute references limit the macro’s ability to function if anything changes, new data is added/removed, or the list gets longer. Relative means the macro’s recorded keystrokes are relative to the starting cell’s location.
Continue reading HERE