learning from vba recorder

[ammartino44]

Hello. I'm improving my vba skills by having the recorder just record my usual actions in excel. I'm not sure if this is good though, because some of the code looks weird. For example, when I input a date it goes ActiveCell.FormulaR1C1 = "12/31/2008". Why does it do formula? Shouldn't it be value?

[BadlySpelledBuoy]

In my experience the VBA recorder is good for "quick and dirty" code. It is by no means brilliant at code writing.
You can learn a lot from it. Just a shame much of that will be how NOT to do something the easy and/or efficient way.

BSB.

[shg]

IMO, the macro recorder is a gift from God for learning VBA and the Excel object model. Try learning the Outlook object model without one.

[jolivanes]

Re "gift from God"

That's the first time I've seen Bill Gates being called that!!!!!!!!!!!

[S O]

Try learning the Outlook object model without one.

Here, here!

[ammartino44]

Ok, then I think I'll keep it open when I'm working in excel. Helps me get more accustomed to code.