VBA Excel - Update cell value after using an AutoFilter

This is a follow-up question of this thread. May I ask if it is possible to update a cell value after using an Autofilter? So, the flow that I'm thinking of is it will filter the data then update the P9 cell wherein this is the first-row result of the filter, with the value of 1.

Below is the code that I'm trying to modify. This code is similar to this thread but this time I need to update it rather than delete it.

For Each ws In Sheets(Array("N-Q1", "N-Q2", "N-Q3", "N-Q4", "N-D", _  "JK-Q1", "JK-Q2", "JK-Q3", "JK-Q4", "JK-D", "SK-Q1", "SK-Q2", "SK-Q3", "SK-Q4", "SK-D"))         With ws.Cells(8, 3).CurrentRegion       .AutoFilter 2, LRN       ws.AutoFilterMode = False     End With           Next ws    

https://stackoverflow.com/questions/66595368/vba-excel-update-cell-value-after-using-an-autofilter March 12, 2021 at 02:41PM