Macro to VB Code

[Range]

Is there any benefit/cons in recording a macro and then transfering the code to a command button, etc in terms of speed/memory, etc. Thanks

 

[Nalani]

To answer your question - No there is no difference when assigning your Recorded Macro/code to a button.

All you have done there is, instead of Running your macro from the Macros Dialog box is assigned it to a Button. It will still run as you have Recorded it.

Keep in mind that the Recorder, which is a good tool to get started on, does put in unneccessary steps that can be eliminated. This in turn Will make the code run faster.

Example with the Recorder:

Sub Macro1()
'
' Macro1 Macro
'
'
    Range("A1:A4").Select
    Selection.Copy
    Range("C1").Select
    ActiveSheet.Paste
End Sub

Same code modified:

Sub Macro2()
    Range("A1:A4").Copy Range("C1")
End Sub

In a nutshell, you normally do not have to Select or Activate when using VBA.

 

[Range]

ahh sweet point mate - thanks.

So in terms of learning to code more efficiently its mainly a case of understanding VB better. **** that means lots of reading and less cheating.