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.


---
Message posted from http://www.ExcelForum.com/

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

"Novice" wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/

The record at mark functionality was eliminated in Excel 97

Stephen Bullen wrote a record at mark addin. I haven't used it, but perhaps
it would work for you.

http://www.bmsltd.co.uk/Excel/Default.htm

--
Regards,
Tom Ogilvy


Novice wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/

Where do I save the Record at Mark.xla file on my hardrive?


---
Message posted from http://www.ExcelForum.com/

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
ToolsAdd-ins it would be available to checkmark for use.

Gord Dibben Excel MVP

On Thu, 18 Dec 2003 18:47:29 -0600, Novice
wrote:

Where do I save the Record at Mark.xla file on my hardrive?


---
Message posted from http://www.ExcelForum.com/