View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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