Insert serial Number Automatically In Wortksheet Excell VBA

This channelTo broadcast videos just Share Only I know the information Excell VBA And Computer Clips
Thankyou

For More Details Or VBA Code Please Vsit

Please Visit facebook Page
Vist My Web

[sallytong]

THANK YOU! That's very useful. I am wondering if I can add text before the number? for example the number will start from INV00003, Pls advise.

[sokhengban]

Hello sir. When we want to delete some row, The Serial Number is keep in order or not sir?

[muychamnan]

Thank you for your sharing but how I use it on the form?

[kidsworld]

How to start this numbering from d4 cell which is starting of my serial number cell plz help me.

[syedalam]

I really like your video and try to implement the same code in one of my membership spreadsheet. but its not working as my First column (Last Name) starts at C4, when I am using the code with proper alteration, I am unable to get "1" (under SR. NO.) column. It is starting from 2 and its showing at "A3" My codes are:
Private Sub Target As Range)
Dim i As Long
i =
If i > 1 Then
Sheet1.Range("A" & i).Value = i - 1
End If
End Sub

Would you please help me out and give me the correct codes.
Thanks a lot.

[peterw]

if my start cell is on A3, my infor cell is on D3 how to amend the code? i try to do
it at Private Sub Target As Range)
Dim i As Long
i = )
If i > 1Then
Sheet4.Range("A" & i).Value = i - 1
End If

End Sub

how about the Sheet4.Range("A" & i).Value = i - 1, how to make the starting cell start at A3
Please assist me