WHAT IS A MACRO IN EXCEL USED FOR HOW TO
If you aim to become an Excel pro, then you should definitely know how to start a macro not only from Excel, but also from the Visual Basic Editor. Once the shortcut is assigned, simply press that key combination to run your macro. For example, if you assign Ctrl + f to a macro, you will lose the ability to call the Find and Replace dialog. It is recommended to always use uppercase key combinations for macros ( Ctrl + Shift + letter) not to override the default Excel shortcuts.