Macro to change filter settings not working

I have filter applied to a column where the data is any positive whole number or 0. The data is populated dynamically using other tables which data is entered and resorted before populating the the table which I am trying to filter. E.g. I can have a series of 0s, 100, 150, 50, 200. After putting in new data elsewhere, I may have an additional 130, 160, etc.

I need to have a way of refreshing this table to show current data that is non-0. Thus have recorded a macro where it changes the filter to 'Select All' values, and then update the filter to omit '0' values. I have assigned this to a button to execute the macro to make it easier for my end users.

Unfortunately, the macro doesn't seem to get the 'Select All' part correct. New values introduced into the table since the macro's recording are also omitted along with the '0' values.

Should this be happening? Is there any way around this?

OK, I've looked at the code for the macro and it's showing all the values selected at the time the macro was recorded. I'm assuming this means that only these values will be selected on running the macro and thus any new values will not be left selected.

Is there anyway to change the code to say 'deselect 0' rather than 'select X, Y, Z values'?