Empty lines in my Sub Total

[lbri7]

Hi,

When i use Sub Totals on a spreadsheet that i previously deleted some rows, Excel still thinks that these rows still have Data and put the last Sub Total after the last row (before deletion).

Ex: Spreadsheet have 500 rows...i delete the last 300 rows. Than i select all and do two Sub Totals... the result is a gap of 300 empty lines before i see the last Sub Total.

Is there anything to do to avoid this problem? All manipulation of my spreadsheet is done in VBA... but it is doing the same thing if done directly in the Spreadsheet.

Thanks

Forgot to say, i don't want to Save the worksheet at this moment because i want the user to be able to discard the changes if he dont want to keep it.