Hi,

I have a named range which includes about 6columns and 6 rows. When a user
inserts a row within the named range, I need a SUMIF formula to be added in
the last column of the inserted row. I've pasted my current Worksheet_Change
Sub routine below, but I'm not too sure how to amend it so the code that I
currently have still works and the macro will also add the SUMIF formula when
the row is inserted.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim FilteredClients As Range
If Not Intersect(Target, Target.Worksheet.Range("ClientCells")) Is
Nothing Then
ThisWorkbook.PopulateValidationLists
End If
End Sub


Help is greatly appreciated. Thanks.
Simon