Possibility of recording while editing a macro?

[jjsauer]

Hello,

I would like to enable the recording function while I am editing a macro. Sometimes I have no idea what, or cannot remember, particular programming language such as Paste Special stuff.

Is there a way to record an action while you are in the process of editing a macro to add in extra little bits.

If not, anybody have a website with a cheat sheet of common macro commands?

Thanks in advance!

 

[Cindy Ellis]

Hello, and Welcome to Mr. Excel!

I would like to enable the recording function while I am editing a macro. Sometimes I have no idea what, or cannot remember, particular programming language such as Paste Special stuff.

I do this frequently, but it's not a slick as recording the bits to the spot where you are in the macro...and you probably know this already.
Assuming Excel 2007 (and probably 2010, but I'm not sure), there's a "macro recorder" button at the bottom left of the window, below the tab names, just to the right of the status. It will usually record to a new module.
I just record what I need, click the button again to turn it off, and copy/paste from what was captured in the module.

I'm not sure about cheat sheets...I have my own, but my "common" is probably weird

Hope that helps,