Unwanted statements in macro

[aljanga]

Hi Forum Friends
I created the driver macro Mike2 (At first cosisting only of the first 2 lines) with keyboard shortkey +m, to run macro Mike. (In future additionals macros)

Every time I run this macro it adds 2 lines to the Macro
,regardless of the End and Exit sub statements.
Why?? Do not want this to happen.

Please Login or Register  to view this content.

As always. Many thanks for any help.
Al

[Leith Ross]

Hello aljanga,

Why are you using End and Exit Sub in the macro?

[aljanga]

I was trying to stop the automatic addition of the 2 lines
whenever I run the macro.

Please Login or Register  to view this content.

These lines were somehow generated by the macro!
Hence the End and Exit sub statements. However,
they did not stop the addition of statement lines.
Al

[protonLeah]

Please explain more of what you are trying to do.
1. Why write a macro to run another macro?
2. What does the macro "Mike" do?
3. Are these macros in the same or different workbooks?

From what you said:

I created the driver macro Mike2 ...to run macro Mike.

It appears that the line:

Please Login or Register  to view this content.

is in Mike2 so that Mike2 is calling itself recursively with no exit point
so you put in the END & EXIT SUB statements.

[aljanga]

Hi protonLeah
Your statement about "recursively" made a light go on.
I moved the code of Mike into Mike2 as you suggested and the macro
now works fine.
Mike is a macro that copies a series of formulas from P40:P54
to any location in the worksheet where I need them. Do this often.
Many thanks
Al