LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I copy many formulas and keep original cell location? Linda Oz Excel Discussion (Misc queries) 3 October 5th 06 08:31 AM
Link to worksheet whose name is stored in another cell Martin Excel Worksheet Functions 6 September 14th 06 09:07 AM
printing data from different location in same worksheet tikchye_oldLearner57 New Users to Excel 2 March 29th 06 04:29 PM
The Template Wizard retains the original location for my database Packwood Excel Discussion (Misc queries) 0 April 15th 05 05:25 PM
Update second worksheet with changes in original worksheet ZB Excel Worksheet Functions 0 January 26th 05 06:11 PM


All times are GMT +1. The time now is 04:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"