Excel 9 Worksheet does not release RAM on delete

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have encountered the problem with a Worksheet that does not release RAM after a row delete that is discussed in Article Q163263. The solution 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, and then run a "ActiveSheet.UsedRange" statement and then use Go To, Special, Last Cell from the Edit menu, Excel still selects the rightmost cell in row 21. Q163263 says the UsedRange property will release the unused RAM. It doesn't. If I save the workbook, then the UsedRange property is reset, as was necessary with Office 95.. Article Q163263 says UsedRange is supposed to release memory as of Excel 97. Why did we backtrack in Office 2000?
 
What would this be to do with programming modules and VBA in Microsoft
Access - the topic of this newsgroup?

TC


Chelms said:
I have encountered the problem with a Worksheet that does not release RAM
Click to expand...
after a row delete that is discussed in Article Q163263. The solution
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, and then
Click to expand...
run a "ActiveSheet.UsedRange" statement and then use Go To, Special, Last
Cell from the Edit menu, Excel still selects the rightmost cell in row 21.
Q163263 says the UsedRange property will release the unused RAM. It
doesn't. If I save the workbook, then the UsedRange property is reset, as
was necessary with Office 95.. Article Q163263 says UsedRange is supposed
to release memory as of Excel 97. Why did we backtrack in Office 2000?
 
Back
Top