HDTutorial
EN
Excel Tutorial - Sequential number macro - Excel VBA

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Excel Tutorial - Sequential number macro - Excel VBA

30,846 views October 26, 2016 2:59

Watch on YouTube
ChannelTwoperscent

Description from the creator

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.

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

About this tutorial

Twoperscent published this 2:59 video tutorial on October 26, 2016. It has been watched 30,846 times on YouTube.

Category
Education
Duration
2:59
Published
October 26, 2016
Views
30,846
Likes
63

Tags

Share

This tutorial in other languages