How to create arrow buttons in Excel to scroll the table left and right

Question

There is a table in an Excel document with numerous columns (which do not fit on the screen). Are macros capable of navigating to a table's right- and left-most columns? Because this is a pivot table, the number of columns varies from day to day. For example, the first day has 20 columns, the second day has 50, and so on.

The sheet already has up and down buttons with the following macros:

Sub TableDown()
Application.SendKeys ("^{END}") 'moves to bottom of table
End Sub

Sub TableUp()
Application.SendKeys ("^{HOME}") 'moves to top of table
End Sub

Is it possible to implement scrolling to the left and right edges of the table in a similar way?

Answer 1

Ctrl-shift-home goes to the upper-left of all columns, and ctrl-shift-end goes to bottom-right of all columns. Hopefully that helps some.