AUTOFILTER causes the file size to increase

I see there are many posts in this Forum dealing with size-increasing macros, most of them blaming it on unused rows, cells or blanks. That’s not the case for me now.
I think I’ve tracked the cause to the Data/Filter function of Excel (or perhaps to the Data/Subtotal function???). Here:

My file is a list of rows with figures in one column, and also with subtotal rows from time to time (these have been obtained by some previous code in my macro calling for the Data/Subtotal function of Excel).
Now, further down, some other code lines in the macro filter the list to show only the rows beginning with “Total” or, alternatively, showing all lines; here is the filtering code:

Please Login or Register  to view this content.

That works O.K., but the size of my file may increase by about one megabyte, depending on when I save it, thus:

- If I save my list for the FIRST TIME after running the filtering macro lines (that is, with only the Subtotal rows shown), then the size of the file will be increased by a mega.
And even if subsequently I unfilter my list and save it again as unfiltered (that is, with all rows visible), the size will remain so increased.

- But if I save the list for the FIRST TIME before running the filtering macro lines (while still showing all the rows), then the size won’t be increased at all.
And even if subsequently I filter the list and save it again as filtered (that is, with only the Subtotal rows visible), the size will still remain unincreased.

- Finally, if I do the filtering MANUALLY (not by executing the macro), then the size of the file will never increase in size, whether I do the first saving with the list filtered or unfiltered.

Is all this just a confusing mess or does it suggest a possible remedy to you, experts out there? Thank you in advance.
ACA

Avoid using select and activate in VBA.

Please Login or Register  to view this content.

Are you sure any cell in column C contains 'total' ?

The code must be put into the macromodule of the sheet you want to filter.

Thank you for not giving up.
Yes, to both your questions: in fact, I tried substituting your code lines for mine own in my macro.
Only that in my original message I copied my 2 code lines with an error; what I have, actually, is this (not the word "selection")

Please Login or Register  to view this content.

I Think that's what I got when recording the actual steps for the filtering function.
Thanks again.
ACA

Since you don't give the impression to be inclined to post a sample workbook, cfr. the attachment.

Ergo:

- the size has nothing to do with autofilter
- autofilter works independently of 'empty' cells

I don't bother reading and understanding Spanish.

Most of the time the file size is due to a difference between 'usedrange' and the range containing real values.

You can test that with

Please Login or Register  to view this content.

You can reduce the sheet to the range containing real values using the hyphenated code. Save the workbook; you will notice it's size has been reduced (probably drastically).

Please do not introduce religious stuff in a non religious forum.

You could have mentioned you wanted to filter on 'totales' in cells that contain more information. Cfr the attachment.

I stated before: The code must be put into the macromodule of the sheet you want to filter
But you didn't.

In my previous post I forgot to add the attachment.