reset last used row and cell
 

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

reset last used row and cell
 

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