Forum Discussion

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

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

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..