How do i page left or right a set number of columns, rather than

B

bflorea

i am wondering how i can set this up so i can page left or right a set number
of columns rather than paging left or right controlled by the data in cells?

For example: with no data in any cells, and you hit Ctrl + right arrow it
takes you all the way to the end of columns (xfd)??

If i have columns A-I showing, why can't i hit Ctrl = right arrow and move
to J-R??

Thanks
 
S

Simon Lloyd

You need to add a macro buttons and assign these macros:


Code:
--------------------
Sub Shift_Right()
ActiveWindow.LargeScroll ToRight:=1
End Sub

Sub Shift_Left()
ActiveWindow.LargeScroll ToRight:=-1
End Sub

--------------------


bflorea;571482 said:
i am wondering how i can set this up so i can page left or right a set
number
of columns rather than paging left or right controlled by the data in
cells?

For example: with no data in any cells, and you hit Ctrl + right arrow
it
takes you all the way to the end of columns (xfd)??

If i have columns A-I showing, why can't i hit Ctrl = right arrow and
move
to J-R??

Thanks


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top