Visit Debra Dalgleish's site:
http://contextures.com/xlfaqApp.html#Unused

Roger Smith wrote:

Hi Excel Experts

Is there any way to programmatically set the UsedRange or some other way to
reset the last used row and cell to the real edges of the document so the
horiz and vert sliders work correctly?

Thanks much

--

Dave Peterson