ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

2 Q & A posts tagged with scroll

Thu
Apr 23
2009

[Excel/VBA] How to prevent excel to scroll up after typing ?

Hi

Each time I enter something at the bottom of a sheet, excel scrolls up the page (half of window height).
Is there a way to prevent (or reduce) this ?

Or some VBA to place a given row (last one) at the bottom of the window ?

Thanks in advance


Answer

First part of your question, no is the answer

For the second part, yes there is, it will depend on the Zoom percentage you are having and the height of your Excel screen

Try doing a macro to...
1- Scroll to the end of the end of your table (last row on your table)
2- Scroll back up to 10/20/30 rows
3- Activate any cell in the last row of your table

Something like this

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


You need to try it and change the 20 to what ever suitable for you



Good luck



VBAXLMan

Thursday 4/23/2009 11:24:16 PM
Thu
Apr 23
2009

Excel line between rows 264 and 265?

If you scroll in your all the way down in excel you will see a black line between does two rows. Is there any point to it?


Answer

That usually because you had data before (or Format cells) up to these rows and deleter them using Clear and not delete

To get rid of that, you should "DELETE" the rows (Right click and select "Delete")

This will also reduce the size of your file

If you have any problems or didn't understand the answer, mail me here


VBAXLMan

Thursday 4/23/2009 3:32:19 PM

Tags

History