Hi Ranew,
As a workaround, what I would recommend you is to:
- Create a column called (for example) SUM_ALL where it would contain the sum of the values from columns A to Z
- Then use the Worksheet_Change event in the sheet you want to do that. In that event you would re-apply a filter where SUM_ALL <> 0
See example below (considering your table is from A1 to Z:1000, for example. And that the SUM_ALL column is AA, but you can adjust that using your Const). Please notice the code below will have to be inside the sheet with that filter:
Good luck
Bookmarks