Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error when run macro (2000)

    On trying to run a macro l get an error, see atatchment.

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

    Re: Error when run macro (2000)

    What code are you executing, and what is highlighted when you click Debug?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error when run macro (2000)

    Nothing is highlighted ,Do you want to see the code?
    This is the coding:

    Very long code fragment (over 7,000 characters!) moved to attachment by HansV

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

    Re: Error when run macro (2000)

    The code you posted contains three macros. Which of the three were you trying to run when you got the error?

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

    Re: Error when run macro (2000)

    > Nothing is highlighted

    I wrote that you should click the Debug button in the error message. If you do, a line of code will be highlighted.

  6. #6
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error when run macro (2000)

    DAPU lines.

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

    Re: Error when run macro (2000)

    The macro tries to delete lines (graphic objects) named Line 5, Line 4, Line 3, Line 2 and Line 1 from the active worksheet. If there are no lines with those names, you'll get an error message.

  8. #8
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error when run macro (2000)

    Thanks for that. I will bear that in mind next time l do a macro.

Posting Permissions

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