Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Watch Macro Run (2003)

    Hi,
    I am working on a macro in Excel and I'd like to run the macro but have it run one line at a time so I can watch it. How can I do this?
    Thanks,
    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Watch Macro Run (2003)

    Position the Excel and Visual Basic Editor side by side, or at least in such a way that you can see the code and the relevant part of the workbook.
    Click somewhere in the macro code, then press F8.
    Each F8 will execute one line of the macro. There is also a "single step" button on the Debug toolbar.
    If you want to run the rest of the macro automatically at a certain point, press F5.

  3. #3
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Watch Macro Run (2003)

    Thank you.
    Deb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •