Hi,

I have written within VB a number of routines whcih involve loops. I
summary a sheet is created by opening other workbooks and grabbin
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 maste
worksheet when saved is approximately 3MB (even thought there i
minimal data)

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

Thanks, Ajay

--
atreo
-----------------------------------------------------------------------
atreon's Profile: http://www.excelforum.com/member.php...fo&userid=3105
View this thread: http://www.excelforum.com/showthread.php?threadid=50722