Automatically re-apply filter when data changes

[JoeMSC]

Hey all,

I'm trying to get a table to re-apply filters when one of the blank cells changes (blank cells are currently filtered out), I don't change the value of the cells in the table manually, they are formulated.

This is the macro I tried, but it doesn't seem to work:

Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("Symbol Bar Chart Reference").ListObjects("Symbols").AutoFilter.ApplyFilter
End Sub

Would greatly appreciate some help with this one.

J

[TMS]

A Worksheet Change Event handler doesn't fire for changes in formula values. It only fires if a cell value is changed manually or via VBA.

[JoeMSC]

A Worksheet Change Event handler doesn't fire for changes in formula values. It only fires if a cell value is changed manually or via VBA.

Well shoot, is there a script that can be written that fires the Change Event handler when a unique value is added to a range?

[TMS]

You could maybe use the Calculate Event handler. See: https://docs.microsoft.com/en-us/off...alculate(even)