Excel 2003 - VBA - Macro Recording

[Craig Brandt]

I have been using Macro Recording as a means of creating and understanding
macros.
Now when I want to add a function to a macro I record a separate macro, then
edit it into my existing macro.

Is there a way to start record steps within a macro already created.

Thanks,
Craig

 

[Jim Cone]

Craig,
Older versions (how old?) of Excel had the record at mark capability.
You could record a new macro starting at specific position in an existing macro.
Excel was then "improved" and that feature eliminated.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Craig Brandt"
wrote in message
I have been using Macro Recording as a means of creating and understanding
macros.
Now when I want to add a function to a macro I record a separate macro, then
edit it into my existing macro.
Is there a way to start record steps within a macro already created.
Thanks,
Craig

 

[Gord Dibben]

Craig/Jim

Excel 97 was first version without the "record at mark"

Stephen Bullen designed an add-in that that emulated the feature.

See this google thread for more info.

http://tinyurl.com/ynmnfn


Gord Dibben MS Excel MVP

 

[Jim Cone]

Gord,
Thanks for the info.
I guess I am older then I thought.<g>
Jim Cone


"Gord Dibben"
wrote in message
Craig/Jim
Excel 97 was first version without the "record at mark"
Stephen Bullen designed an add-in that that emulated the feature.
See this google thread for more info.
http://tinyurl.com/ynmnfn
Gord Dibben MS Excel MVP

 

[Craig Brandt]

Thank you all.
I will give this addin a try, as the benefits are significant.

Thanks again,
Craig

 

[Craig Brandt]

The link in Jim's note takes you to Stephen Bullet's memo. The link on
Stephen's memo didn't work for me so I when to Shephen website
http://www.BMSLtd.co.uk and found it there.
Now to go off and try it.

Thanks again,
Craig