Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2008

Tip: Looking for answers? Try searching our database.

Excel 2003 - VBA - Macro Recording

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Craig Brandt - 07 Feb 2008 16:35 GMT
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 - 07 Feb 2008 17:33 GMT
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.
Signature

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 - 07 Feb 2008 18:40 GMT
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,
>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 - 07 Feb 2008 18:48 GMT
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

On Thu, 7 Feb 2008 09:33:26 -0800,
"Jim Cone"
wrote:
>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.
Craig Brandt - 08 Feb 2008 14:46 GMT
Thank you all.
I will give this addin a try, as the benefits are significant.

Thanks again,
Craig

> Gord,
> Thanks for the info.
[quoted text clipped - 17 lines]
> >You could record a new macro starting at specific position in an existing macro.
> >Excel was then "improved" and that feature eliminated.
Craig Brandt - 08 Feb 2008 14:59 GMT
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

> Gord,
> Thanks for the info.
[quoted text clipped - 17 lines]
> >You could record a new macro starting at specific position in an existing macro.
> >Excel was then "improved" and that feature eliminated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.