where is the original data location in a worksheet stored?
 

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

where is the original data location in a worksheet stored?
 

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


"z.entropic" wrote in message
...
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

where is the original data location in a worksheet stored?
 

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

On Thu, 20 Dec 2007 13:26:01 -0800, z.entropic
wrote:

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