View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default 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