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.
Bookmarks