XL97: New UsedRange Property Behavior (163263)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q163263 SUMMARY
In earlier versions of Microsoft Excel, when you create a Visual Basic for
Applications macro that performs multiple deletions or clears cells
multiple times, you must save the workbook to release the random access
memory that is no longer being used. In Microsoft Excel 97, you can free
this memory by using the UsedRange Property in a macro.
Additionally, the UsedRange property in Microsoft Excel 97 refers to only
the occupied range of cells. In earlier versions of Microsoft Excel, the
UsedRange property includes cells that are referred to (by formulas) but
not occupied with data.
NOTE: The UsedRange Property does exist in earlier versions of Microsoft
Excel. This particular functionality is new in Microsoft Excel 97.
This article contains a sample macro that resets the used range of cells on
the active worksheet.
REFERENCES
For more information about the UsedRange Property, click the Office
Assistant in the Visual Basic Editor, type the following text
and then click Search. Click "UsedRange Property" to view the help topic.
topic.
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Visual Basic Help is not installed on your
computer, please see the following article in the Microsoft Knowledge Base:
120802 Office: How to Add/Remove a Single Office Program or Component
Modification Type: | Major | Last Reviewed: | 6/23/2005 |
---|
Keywords: | kbProgramming KB163263 |
---|
|