Hi Ajay,

See Debra Dalgleish's suggestions for resetting the Used Range at:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman



"atreon" wrote in
message ...

Hi,

I have written within VB a number of routines whcih involve loops. In
summary a sheet is created by opening other workbooks and grabbing
information from each and appending to my master sheet.

There are no formulas.

Although it is simple enough to do tis the end result is the master
worksheet when saved is approximately 3MB (even thought there is
minimal data)

Can anyone suggest anything (i.e. like within Access where you
compress/compact and repair the database)

Thanks, Ajay.


--
atreon
------------------------------------------------------------------------
atreon's Profile:
http://www.excelforum.com/member.php...o&userid=31050
View this thread: http://www.excelforum.com/showthread...hreadid=507227