| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll to the right or left
Using VBA is there any way to scroll left or right on a worksheet?
ex: I've scrolled over to column C and I want to be able to scroll back to column A. While debugging I can see that in Application.Windows(1).ActivePane.VisibleRange it knows what column it's scrolled to, but I can't change it. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Scroll to the right or left
ActiveWindow.ScrollColumn = 1
-- Regards, Tom Ogilvy "James Martin" wrote in message oups.com... Using VBA is there any way to scroll left or right on a worksheet? ex: I've scrolled over to column C and I want to be able to scroll back to column A. While debugging I can see that in Application.Windows(1).ActivePane.VisibleRange it knows what column it's scrolled to, but I can't change it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my mouse won't scroll left or right in excel but will in other pr. | Excel Discussion (Misc queries) | |||
| My scroll wheel, scrolls right to left, not up and down? | Excel Discussion (Misc queries) | |||
| How do I change mouse scroll from left and right to up and down? | New Users to Excel | |||
| Scroll two columns on right while left is stationary | Excel Discussion (Misc queries) | |||
| Mouse scroll jumps from up/down to left/right | Excel Discussion (Misc queries) | |||
![James Martin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
