Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error with macro after recording
Hi all
I have some error and don't know how to resolve it. Basically I did record a workbook with 10 worksheets. I make changes of graphic in each worksheet and move to another worksheet. When running again I had some errors below. Windows("sheetname1.xls").ScrollColumn = 15 ActiveWindow.SmallScroll ToRight:=3 Any idea to fix this are welcome Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error with macro after recording
Those are lines that captured you moving the spreadsheet on the screen
with either your mouse or scrollbar. You should be able to remove them completely with no ill effects. Daniel wrote: Hi all I have some error and don't know how to resolve it. Basically I did record a workbook with 10 worksheets. I make changes of graphic in each worksheet and move to another worksheet. When running again I had some errors below. Windows("sheetname1.xls").ScrollColumn = 15 ActiveWindow.SmallScroll ToRight:=3 Any idea to fix this are welcome Daniel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error with macro after recording
Thanks but how do I know which lines are capture when moving by mouse or scrollbar? Thanks Daniel "JW" wrote: Those are lines that captured you moving the spreadsheet on the screen with either your mouse or scrollbar. You should be able to remove them completely with no ill effects. Daniel wrote: Hi all I have some error and don't know how to resolve it. Basically I did record a workbook with 10 worksheets. I make changes of graphic in each worksheet and move to another worksheet. When running again I had some errors below. Windows("sheetname1.xls").ScrollColumn = 15 ActiveWindow.SmallScroll ToRight:=3 Any idea to fix this are welcome Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Recording Macro | Excel Discussion (Misc queries) | |||
Mac issue with macro recording user login & date (run time error ' | Excel Programming | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions |