Deleted entire row, but numbering series gone wrong. Help me.

Logit · #4 06-23-2020, 08:43 PM

.
By slightly editing the posted macro, you can achieve the goal you desire :

Code:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim I As Integer
    I = 1
    Application.EnableEvents = False
    For I = 1 To 50
        Range("A" & I).Value = I - 1
    Next
    Application.EnableEvents = True
End Sub

The above is designed to delete one row at a time and still maintain the
correct numbering in your column. Your original post indicated you are
deleting one row at a time.

It has been a pleasure helping you. Stay healthy !

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Occurence appt invitees showing on entire series	doresa69	Outlook	0	11-11-2016 01:32 PM
Series numbering	ericjowens	Excel	2	09-03-2015 11:20 AM
deleted items in wrong mailbox	Flip	Outlook	2	03-12-2014 03:51 AM
Header numbering is wrong	Scaffold	Word	2	02-13-2014 03:08 AM
Continue Auto Numbering Throughout Entire Presentation	craigfu	PowerPoint	3	05-04-2012 05:42 AM