I tried with the info from Debra's site as well as a Macro from
David McRitchie, http://www.mvps.org/dmcritchie/excel/lastcell.htm
Davids has worked very well with other sheets, but not his one?


--
MJM


"Ron de Bruin" wrote:

See Debra's site
http://www.contextures.com/xlfaqApp.html#Unused

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"MikeM" wrote in message ...
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