Quote:
|
ctrlF11 opens a macro tab
|
From the link provided, you may have missed this...
Quote:
Open the VBA editor
Open the VBA editor with the shortcut Alt+F11.
|
Paste code in a Normal module - Where to paste code
- Highlight macro to copy >> Ctrl + C >> Open your workbook
- Alt + F11 >> opens the Visual Basic Editor (VBE)
- Ctrl + R >>opens the Project Explorer (if not already open on left side of screen)
- Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
- Paste code >> Ctrl + V (right side of screen)
- Alt + Q >> exits VBE and returns to Excel
- Back in Excel >> Alt + F8 >> Macro Dialog Box >> Highlight macro >> Run
Make sure you are on the sheet you want to run the macro on before you run the macro.
In the macro provided I did not qualify the sheet.