Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For chip about scroll
If i want to scroll a particular cell beside a particular column
lets say column (c).What change do i have to make to chip macro. I want every time i press a button the specfied cell to come next to column c Of course i am using <Freeze panes at column c. Thanks in anvance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
For chip about scroll
Hi Gus,
Try this if your trying to acheive a screen position for a particular cell. Application.Goto Range("C10"), True 'or the same is Range("C10").Select ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollRow = 10 Regards, Rocky McKinley "GUS" wrote in message ... If i want to scroll a particular cell beside a particular column lets say column (c).What change do i have to make to chip macro. I want every time i press a button the specfied cell to come next to column c Of course i am using <Freeze panes at column c. Thanks in anvance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chip Pearson's Forum Etiquette | New Users to Excel | |||
Ping Chip Pearson | Excel Worksheet Functions | |||
Thank you Chip Pearson | Excel Discussion (Misc queries) | |||
Chip Pearson- you're web page is down | Excel Discussion (Misc queries) | |||
Test to see if a worksheet exists thanks, Chip | Excel Programming |