Adjusting the Scroll Bar; Special Case

Hello,

a cell that you modified (format or height) counts the same as if it were filled for the evaluation of the used range.
So either you delete them (manually or via macro), or you deal with it.
eric

By constantly trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it does happen!!!), remember to mark it as resolved. Thank you.

Hi Daniel, Eric,

Thank you for getting back to me! As I said, it's really a special case and I can manage, but I really like to completely understand what's going on...

Daniel:
I had already seen your method with the ScrollArea and although there is a slight improvement, it is still not as good as Excel's usual adjustment using the method of deleting the bottom rows.
For example, in my case, my last filled row (around 1300) is about halfway down the scroll bar. If I go too far down when I scroll, it will "return" to the center of the screen and I will be right at my last row... It is true, once again, that it’s a bit better than being left in the middle of nowhere, but in fact, it only reduces the size of the bar (especially if we have a lot of rows).

Eric:
Sorry, I didn’t really understand your explanation... When you talk about a filled cell, does that mean it acts as if it contains the maximum number of characters that can be put in an Excel cell?
In any case, I tested something else thanks to your response because I thought I had tried everything; I’m not sure all the steps are necessary but it works even if it remains a bit of a convoluted process... Duplicate the sheet, delete all the rows except the first ones, duplicate this new sheet and then paste the cells I deleted from the original sheet...

If there’s something simpler, don’t hesitate! :)

Have a great weekend and thanks again!