I have encountered the problem with a Worksheet that does not release RA
after a row delete that is discussed in Article Q163263. The solutio
suggested in Q163263 does not work for Excel 9.0.2720

Given 21 rows of data on a worksheet, if I delete the 21st row, the
run the macro
Sub Reset_Range(
ActiveSheet.UsedRang
End Su

Then I use the Edit Menu - Go To, Special, Last Cel
Excel 9 still selects the rightmost cell in row 21, should be row 20
If I save the workbook, then the UsedRange property is reset, as i
was with Office 95.
Q163263 says the UsedRange property will release the unused RAM as of Excel 97. I
doesn't. What happened between Office 97 and Office 2000

I'm conducting these same operations using Autmation with MFC and getting the same results.