Excel Tutorial - Sequential number macro - Excel VBA

This video outlines how to add a new row using a macro in excel, but also include a sequential number in the new row. If you have not seen the last video please click the link below. https://www.youtube.com/watch?v=XBi_cUCik6s The added code in this video is as follows: Sheets("Sheet1").Range("a4").Select ActiveCell.Value = "=a5+1" If you have changed the sheet name to something different, you will also need to reflect this change in the "Sheet1" area. When modifying this code, the modifications need to happen within the ""'s. IE "d2".