The reason to copy the current sheet to a new one is also because it's backed up (rather than backing up the entire book)

When I do this
ActiveSheet.Copy
ActiveSheet.AutoFilterMode = False

ActiveWorkbook.SaveAs ...
There is an extra row at the end. However, if I disable the filter *before* cloning the sheet, like this:

ActiveSheet.AutoFilterMode = False
ActiveSheet.Copy

ActiveWorkbook.SaveAs ...
No extra row is added. So cloning a sheet with an active filter is what creates this extra row.


If I were to do this approach (unlike removing last row when there is) would it be possible to turn the previous filter back on (only if there was a filter to begin with)?

Thanks again for your time.