Error when run macro (2000)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

DAPU lines.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

> 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.

Reply | Quote