ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Recording Macro (https://www.excelbanter.com/excel-discussion-misc-queries/180067-recording-macro.html)

carrera

Recording Macro
 
Dumb question....
If you have recorded a macro, later wish to add 1 or more steps to it, is
there a way to just add to the recording, without having to write or cut and
paste code into it?

Dave Peterson

Recording Macro
 
Nope.

Maybe you could record a new macro and copy|paste from there.

Or add a line to your first macro that calls the second macro????


carrera wrote:

Dumb question....
If you have recorded a macro, later wish to add 1 or more steps to it, is
there a way to just add to the recording, without having to write or cut and
paste code into it?


--

Dave Peterson

FSt1

Recording Macro
 
hi
not that i am aware of. the macro either has to be re-recorded from the
beginning or edited.
most recorded macros need to be edited anyway to remove any unneccessary
actions the point and click process may have generated. typically a recorded
macro generates far more code than is accually needed and most can be trimmed
down which usually impoves speed and efficiency.

regards
FSt1

regards
FSt1

"carrera" wrote:

Dumb question....
If you have recorded a macro, later wish to add 1 or more steps to it, is
there a way to just add to the recording, without having to write or cut and
paste code into it?



All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com