How-to refresh Autofilter through Macro in Spreadsheets

Desktop editors
,
1

Hi,

Could you please let me know how can I set up similar macro in ONLYOFFICE? Or is this possible to do it in the UI?

I couldn’t find any similar functions to it, and I had no luck going through the documentation.

I use this to refresh the filter when a calculation is done to show/hide rows.

Private Sub Worksheet_Change(ByVal Target As Range)
    ActiveSheet.ListObjects(1).AutoFilter.ApplyFilter
End Sub

Sub RefreshFilter()
    ActiveSheet.ListObjects(1).AutoFilter.ApplyFilter
End Sub
2

Hello @marcel :wave:

Could you please clarify what exactly happens when the macro is executed? Does it simply refresh the filter after calculations, or does it trigger any specific behavior?

If possible, please provide a document and/or a video demonstrating the expected behavior. This will help us better understand your request.

In the meantime, you might find this method useful for updating data on the worksheet:
Recalculate Worksheet Values