Prev: how to disable automatic full screen mode?
Next: Sorting in a protected sheet
From: Joe M. on 5 Feb 2010 12:40
Is it possible to add a recording to an existing macro? The only way I have
been able to to so this is to create another recording and then copy the code
from the addition and paste it into the first macro. It just seems there
should be an easier way.

Thanks,
Joe M.
From: Eduardo on 5 Feb 2010 12:48
Hi,
the best way is to write the macro from the beginning as per your
explanation that is the only way you have to add something to the macro

"Joe M." wrote:

> Is it possible to add a recording to an existing macro? The only way I have
> been able to to so this is to create another recording and then copy the code
> from the addition and paste it into the first macro. It just seems there
> should be an easier way.
>
> Thanks,
> Joe M.
From: Jim Thomlinson on 5 Feb 2010 13:00
You can not append a new recording to an existing macro. There are 2 solutions.
1. copy and paste as you have done
2. Make a call from the original macro to the new macro

Sub Macro1()
'original macro
call Macro2
end sub

Sub Macro2()
'New macro
end sub
--
HTH...

Jim Thomlinson


"Joe M." wrote:

> Is it possible to add a recording to an existing macro? The only way I have
> been able to to so this is to create another recording and then copy the code
> from the addition and paste it into the first macro. It just seems there
> should be an easier way.
>
> Thanks,
> Joe M.
 | 
Pages: 1
Prev: how to disable automatic full screen mode?
Next: Sorting in a protected sheet