Hello, I had created a forum question yesterday which worked with the VBA code someone gave me:


Public Function PreviousDate(SearchRange As Range, CurrentDate As Variant) As Variant

For Each c In SearchRange
If c.Value < CurrentDate And c.Value > PreviousDate And c.Offset(0, -5) = "Active Client" Then
PreviousDate = c.Value
End If

Next c

End Function
I had to create an array formula to another cell and now the code doesn't work anymore. Is there something i need to change to the code now so it will work again? Please help. See attached.
Book4.xlsm