Thanks Gord,
I am able to do it, yet I was wondering if there is an actual tool that does
that. When I searched on Google, I found that Sobolsoft has a tool. Yet due
to the fact that all of the trial versions need you to actually sign up and
pay to use it, I am reluctant to buy it without trying it.
I want a tool that our users are able to use so they can fix this process
themselves.
Rima
"Gord Dibben" wrote:
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