Preston Meadow's Height Enhancement Blog

[Excel / VBA] How to prevent Excel to move up after writing?

Hello Each time you type something in the bottom of a worksheet, Excel moves to top of page (half the height of the window). Is there a way to avoid (or reduce) this? Or some VBA to place a given row (the last) in the bottom of the window? Thanks in advance

First part of your question is not the answer to the second part, yes any, will depend on the zoom percentage you have and the height of the Excel screen Try to make a macro to … 1 – Go to the end of the bottom of the table (the last row of the table) 2 – Scroll to 10/20/30 rows 3 – Select any cell in the last row of the table Something like Sub Showlast () CC = Worksheetfunction.Counta (Range ( "A: A ")) Range (" A1 "). Offset (CC). Activate Range (" A1 "). Offset (CC-20). Activate Range (" A1 "). Offset (CC). Activate End Sub need to try and change 20 to what it always right for good luck VBAXLMan