I found I had a similar problem to this recently.

I have a sheetchange event handler which insists that for certain cells,
the row and/or column "label" cells be populated/edited before these
certain cells are populated. This event handler has been in place for years,
but I only found out recently that it is not triggered if the cell is
autofilled.

I have not yet decided how precisely I'm going to code this solution,
but I have demonstrated to my own satisfaction that propoerly coded,
and copied into the worksheet code area of each sheet of interest (boring),
the following will solve my problem

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.address includes Cell(s)_of_Interest then
React accordingly
end if
End Sub

If anyone can come up with a neater solution, I guess we'd both be grateful.

"Dev" wrote:

Is there a way to track "AutoFill (CopyPaste)" event programmatically?