Thanks guys, that helped... it also explained why it would randomly work!

"Scoops" wrote:


WBTKbeezy wrote:
Does anyone know a good way to clear out the extra space on a sheet that at
one time had data but now doesn't but the scrolling still goes as far down as
the data used to go down? I have tried clear formatting, deleting the rows
and/or columns and the like, but have had no luck. Strike that I have had
random luck, sometimes it kind of works, but only for the rows and not the
columns, any one know how to go about this?

Thanks,

Hi WBTKbeezy

The scroll bars should re-set to the size of the used range when the
workbook is saved.

Regards

Steve