| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy many formulas and keep original cell location? | Excel Discussion (Misc queries) | |||
| Link to worksheet whose name is stored in another cell | Excel Worksheet Functions | |||
| printing data from different location in same worksheet | New Users to Excel | |||
| The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
| Update second worksheet with changes in original worksheet | Excel Worksheet Functions | |||
Linear Mode
