Excel Tutorial - Sequential number macro - Excel VBA

Published: 18 February 2016
on channel: Twoperscent

29,512

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.

• Creating a macro in Microsoft Excel t...

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".

On this page of the site you can watch the video online Excel Tutorial - Sequential number macro - Excel VBA with a duration of hours minute second in good quality, which was uploaded by the user Twoperscent 18 February 2016, share the link with friends and acquaintances, this video has already been watched 29,512 times on youtube and it was liked by 62 viewers. Enjoy your viewing!