Insert number automatically by a click

By Md.shaiful islam Talukder | 12:18 AM |
Insert Auto number.

Any where click in Ms Excel row/column automatically insert number a specific column which column select in VB code and start from specific row as you select in VB .
Now data entry start.Easily auto number insert specific column.
VB code is :
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    rowoffset = 0
    Intersect(ActiveCell.EntireRow, Columns("A")).Value = ActiveCell.Row + rowoffset
End Sub
'To use this UDF push Alt+F11 find sheet where you work and paste in the code. Push Alt+Q and save. 
'--------------------Md.Shaiful Islam Talukder--------- 

0 comments :

Post a Comment

Top^