I need to resize my verticle scroll bar in excell to match my remaining data.
This seems like it should be a simple task. example: I have 100 rows of
data. I use a subtotal function to delete duplicates, which doubles the
amount of rows, and shrinks my scroll bar. After I remove the subtotals, my
scroll bar still takes me down 200 rows while I may only have 50 rows of data
now.

HELP!