VBA codes and Examples in Excel

Repetitive Work Five Rows Down Bold, Then Five Rows Down Italic

1. First open your worksheet
2. Press Macro Recording Button
3. Write Macro Name, Shortcut Key, Store Macro in                                                                       1. Personal Macro Workbook 2. New workbook 3. This workbook.
4. Click where you want to do Bold & Italic (like D2)
5. Press Alt+F11 to see VBA codes
6. Click Module to see codes
7. Now Press - View then Macros then click Use Relative References
8. Then click D2 and drage to D6 (Five Rows)
9. Do Bold them
10. Then Select D7 to D11
11. Italic them
12. Then next five entries do Bold
13. In VBE delete Last code
14. Stop Macros

15. VBA code is here