where is the original data location in a worksheet stored?

[z.entropic]

Here is the observed behavior: when rows or columns of data in the worksheet
are deleted, and when one tries to find the data-occupied worksheet area by
pressing Shift-Ctrl-End for, for example, fast charting, Excel 2003 gives the
old dimensions, not the actual ones.

Where is this old data located in memory, and how to access it?
z.entropic

 

[Rick Rothstein \(MVP - VB\)]

You said "in memory"... are you trying to get the area within a macro? If
so, it looks to me like the worksheet is using its UsedRange property to
track that area.

Rick

 

[Gord Dibben]

The data is not stored in memory, just the markers for those cells.

Excel just forgets to reset the used range after you delete the data.

Delete the rows and columns outside the actual range of data then save the
workbook. You may even have to save. close and reopen.

Excel will reset the used range.


Gord Dibben MS Excel MVP