Did you delete the rows by highlighting them and pressing the Delete key? Or
did you right-click in the highlighted area and click Delete...

highlight row 117, hold the shift key, press the End key, press the
downarrow key, right-click in the highlighted area and click Delete...

highlight column X, hold the shift key, press the End key, press the
rightarrow key, right-click in the highlighted area and click Delete...

close and save the workbook. Reopen.

One other thing, is the workbook shared?

"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