Auto update data with Auto refresh filter in excel using VBA | Refresh the Filtered Data using VBA

#ExcelMagic #ExcelTrick #ExcelVBA #VBA #Cybotech #Nawada #

Here is the Code -
Private Sub Worksheet_Change(ByVal Target As Range)
Sheet1.AutoFilter.ApplyFilter
End Sub
Hi,

Thanks For Watching, Sharing And Commenting Us.

To Watch More Videos Please Visit Our Channel –

Social Links Are –

[veri]

Thanks this video very useful, is it possible to do the same thing in Excel table, also when you insert an extra row?

[veri]

It doesn't work for some reason,
Run-time error'91':
Object variable or With block variable not set.
For me it's important to make it work on a table
I'll be grateful for any suggestions.