"faffo1980" wrote:
> Hi all,
> I would like to know if there is a way to identify which is the index of a
> row deleted from the sheet.
> Browsing the web I found some method to identify a row deletion event but
> not the row index.

> Thanks in advance for the help,

> faffo1980

"Jacob Skaria" wrote:
> Try the below to track row deletions from the used range...Select the sheet
> tab which you want to work with. Right click the sheet tab and click on 'View
> Code'. This will launch VBE. Paste the below code to the right blank portion.
> Get back to to workbook and try out.

> Private Sub Worksheet_Change(ByVal Target As Range)
> Static lngRows As Long
> If UsedRange.Rows.Count < lngRows Then
> MsgBox "Row " & Target.Row & "deleted"
> End If
> lngRows = Me.UsedRange.Rows.Count
> End Sub

> If this post helps click Yes
> ---------------
> Jacob Skaria

> "faffo1980" wrote:

> > Hi all,
> > I would like to know if there is a way to identify which is the index of a
> > row deleted from the sheet.
> > Browsing the web I found some method to identify a row deletion event but
> > not the row index.

> > Thanks in advance for the help,

> > faffo1980