Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I consolidate the following code so that it improves execution time?
I recorded "scrolling" in my macro, and I'd like to consolidate every discreet line/column scroll command. ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 ActiveWindow.ScrollRow = 5 ActiveWindow.ScrollRow = 2 ActiveWindow.ScrollRow = 1 ....so that it resembles something like this: "ActiveWindow.ScrollColumn = 4:1" "ActiveWindow.ScrollRow = 5:1" Thanks you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Consolidating Data | Excel Worksheet Functions | |||
consolidating workbooks | Excel Worksheet Functions | |||
Consolidating??? | Excel Discussion (Misc queries) | |||
Help with Mr. Dave Peterson's Code for Consolidating Many Sheets to One | Excel Programming | |||
Consolidating module code | Excel Programming |