Forum Discussion
Auto-scroll an Excel workbook
DylanBrown It should continue to run just fine, the code looks at the current size of the table each time it runs.
Hello @DylanBrown
You definitely should start working in VBA. If you want to have all the fun that is.
On the Web there are plenty of examples of what you want to do, here are some examples:
https://forum.ozgrid.com/forum/index.php?thread/86754-scroll-screen-to-active-cell-row/
https://www.automateexcel.com/vba/scroll/
https://stackoverflow.com/questions/12636434/how-do-i-make-an-excel-worksheet-scroll-to-a-row-programatically
You could also write some code to remove the row of a completed task from the display.
Let me know if you need more help understanding the code or adjusting it to your needs.
TAKE THE PLUNG you will not regret it at all 😉
GiGi
- I have done a little VBA a while ago but not for anything like this. Would I need some sort of trigger to start the scrolling? I'm planning on having this always on on the TV so it doesn't turn off but just in case it does I don't want it to be a nightmare to start the code again.
I'm just reading through this one that you shared now - https://www.automateexcel.com/vba/scroll/
Little confused where to start.
