wrote...
....
normaly when i click and hold the scroll bar and bring it all of the
way down it will stop at about row 1400.. and if i hold the down arrow
down it will keep going past 1400
....

It's your used range. There are some things that affect its size that can't
be reset by deleting rows (AND COLUMNS) outside the used range then saving
the file. Rather than searching for all of them, it's expedient to insert a
new worksheet, CUT what you believe the used range to be, paste it into the
newly inserted worksheet, delete the worksheet that used to contain it, and
finally rename the new worksheet with the newly deleted worksheet's name.
Then perform a full recalc, [Ctrl]+[Shift]+[F9], and check formulas and
defined names in all other worksheets for #REF! errors.