How to Select All With Excel VBA Macros

1. Press 'Alt' and 'F11' together on your keyboard from within Microsoft Excel.
2. Open a new module by clicking on 'Open' and then 'Module.'
3. Copy and paste the following code into the blank window:Sub Macro1()'' Macro1 MacroCells.SelectRange('J1').ActivateEnd Sub
4. Press 'F5' to run the macro on your worksheet.