Deleting,Earasing,Cleaning cells in Excel.....

[eliW]

Many times after importing a lrge database to Excel and then deleting a good portion of this DB, still Excel "remembers" the whole original range. e.g. when clicking Home+End I got the last original cell even after deleting the whole erea.

questions:
(1) why is that?
(2) how can I really CLEAN the unwanted data to make the cells really empty?

Eli
This message was edited by eliW on 2002-12-31 05:15

 

[Ivan F Moala]

On 2002-12-31 05:14, eliW wrote:
Many times after importing a lrge database to Excel and then deleting a good portion of this DB, still Excel "remembers" the whole original range. e.g. when clicking Home+End I got the last original cell even after deleting the whole erea.

questions:
(1) why is that?
(2) how can I really CLEAN the unwanted data to make the cells really empty?

Eli
This message was edited by eliW on 2002-12-31 05:15

EDIT:
Once you have enter data on a Worksheet Excel needs to remember or recall this info ie. the cells data and properties etc. This is so that it can Undo an operation. The default number of operations is set @ 16, so it needs to remeber or recall a bit a info. To reset the new range just save your workbook OR
Run this code;

Application.UsedRange



_________________
Kind Regards,<font size=+2><font color="red"> I<font color="blue">van<font color="red"> F M</font color="blue">oala</font><font size=1> From the City of Sails

This message was edited by Ivan F Moala on 2002-12-31 06:23

 

[eliW]

Thanks a lot Ivan
Eli