Error with macro after recording

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thanks but how do I know which lines are capture when moving by mouse or
scrollbar?
Thanks
Daniel
 
You must log in or register to reply here.

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

Similar Threads

Print Macro code help 1
Error Message - Macro to Unlink MS Queries from Workbook 0
Excel Macro delete certail column's 1
Run-time error 9 (Subscript out of range) 3
Prompt for filename in excel macro VBA 6
Ron de Bruin - Merge cells from all worksheets 0
Autorun Macro on file opening 1
How To Automate Copy Certian Cells from Worksheet A to Certian Cells Worksheet B? 1

Back
Top