Macro Notes - manishmmulani/macros GitHub Wiki
Alt + F11 -> Opens VBA (Alt + F11 again will take you back to excel)
Alt + F8 -> Opens a dialog showing Macros in the workbook
A few examples on working with Range can be found here
For Loop & Iterable data structures in VB - here