Really Dumb Question

  • Thread starter Thread starter Novice
  • Start date Start date
N

Novice

I typically use the macro recorder to develop the code for me but
sometimes I have to stop. How do I start programming again where I
left off? I know I can create additional code utilizing another
recorded macro and then copy & paste, but this is inefficient. Thanks.
 
Novice,

Put them one on top of the other and get rid of the End Sub
in the first macro and the Sub line in the second macro.

Sub Macro1()
'yadayadayada
End Sub ' Delete this line
Sub Macro2() ' Delete this line
'yadayadayada
End Sub

Another way would be to create a new sub.
Sub MyMacro()
' paste whatever code you need from each macro
End Sub

John
 
Assuming you are referring to Stephen Bullen's Record At Mark.xla...

The latest(2000) version download is an Executable self-install version.

But if all you have is the *.xla........

I would stick it into my Office\Library folder so's when I went to
Tools>Add-ins it would be available to checkmark for use.

Gord Dibben Excel MVP
 
Back
Top