Create a new workbook with that macro in it.

Save that workbook.

When you open a workbook where you have to try to reset that last used cell, you
can open the workbook with the macro.

Then activate any workbook you want.
Tools|macro|macros
select the macro
and click run

All the worksheets in that activeworkbook will be processed.

Eric wrote:

I get 100 spreadsheets to check for resetting the usedrange.
Do you have any suggestions on how to create one spreadsheet to reset the
usedrange for a number of spreadsheets without manually inserting
DeleteUnused code on each sheet?
Thank you for any suggestions
Eric

"Dave Peterson" wrote:

This may help.

Debra Dalgleish does share some techniques for resetting the usedrange:
http://contextures.com/xlfaqApp.html#Unused



Eric wrote:

I get a spreadsheet about 4.6 MB, and try to delete any useless formula for a
table A2:K1000, but I get no idea why the file size for this spreadsheet
increases from 4.6MB to 5.6 MB, which does not make any logical sense.
Will I create some garbage information when I delete those table's formula?
Does anyone have any suggestions?
Thanks for any suggestions
Eric

--

Dave Peterson


--

Dave Peterson