Rima

Debra Dalgleish has VBA code to reset the used range on each worksheet in a
workbook.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 07:23:02 -0700, Rima wrote:

When making excel workbooks, I found that excel puts in a lot of extra
programming, therefore making the size of a workbook go up to 25MB. Which
causes difficulty when e-mailing the workbook. A solution found is by
deleting all extra empty cells, yet this is impractical.
Is there a way to clean it up without having to manually erase all of the
extra cells.

Thanks