Check if cell was auto-incremented

[uAnonimo]

I got a 80k lines worksheet and when it was created, people have dragged down fields and Excel have mistakenly auto-incremented some values.
Is there a way to detect if the field was auto-incremented with VBA and change the next row value that was incremented to the current row value?

Something like:

For Each Row
    If NextRowColumn = ThisRowColumnIncremented Then
       NextRowColumn = ThisRowColumn
    End If
Next Row

 

[Joe4]

Is there a way to detect if the field was auto-incremented with VBA

No. Excel has no memory of how a cell was changed (or even if it was changed after the fact).
You can have a Worksheet_Change event procedure VBA code that can detect changes as they happen, but you cannot look back and determine how it was changed.