Forum Discussion

assuan franco's avatar
assuan franco
Copper Contributor
Nov 08, 2018

vba macro recorder

Hi!, when trying to record a macro (a quick example of assigning value 1 to cell F6) This is the result obtained   Sub Macro1 () ' 'Macro1 Macro '      Range ("F6"). Select      . = "1" End ...
excel
Macros and VBA
Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Nov 09, 2018

the following is what I got..

 

 

Sub Macro1()
'
' Macro1 Macro
'

'
 Range("F6").Select
 ActiveCell.FormulaR1C1 = "=1"
 Range("F7").Select
End Sub

 

  • assuan franco's avatar
    assuan franco
    Copper Contributor
    Nov 09, 2018

    is an example of what the editor does, but it does it with any object, there are times that I do not know some code and with the macro recorder I get an idea of how to do it,

     

    other example, I add a sheet

     

    Sub Macro2()
    '
    ' Macro2 Macro
    '

    '
    .Add :=
    .Enabled.Select
    End Sub

    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Nov 09, 2018
      VB Editor is a nice way of making automated procedures. I often use it and when I bumped into a snag, I post that problem at this forum to get some solutions. There are many good people here who can help. Just post whatever problem you encountered. Suggest that you post your queries one at a time - this way you can learn better, don't go for a quick fix.
      thanks..

Resources