Niek Otten's responsed worked for me

Thanks for the assistance

RW


"Dave Peterson" wrote:

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

RWood wrote:

I've deleteda number of rows (250) yet the worksheet still thinks the
worksheet is it's original size (the scroll bar hasn't changed).

I want to "shorten" the worksheet to it's current size and lose the
formatting for the unused cells.

Thanks

--

Dave Peterson