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

Logit · #1 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 !

kingston123 · #2 06-24-2020, 03:48 AM

Where should I enter this code? How to activate it?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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