try copying a1:w116 to a new, unused workbook.
then delete the old workbook (assuming it doesn't contain macros or
things that would need to be moved over to the new workbook).
hope that helps!
:)
susan



On Jan 20, 1:27*pm, MikeM wrote:
I've tried it all.... *No matter what I do, I can not reset the last used
cell range. *It goes to cell IV65536. *Can I force a reset so that the range
would only be A1:W116?

I ran a few Macros available online, as well as Deleted all rowa except the
ones I wanted. I closed and reopened, I reset any and all mergerd cell... I
am stumped!
Hlpe
--
MJM