Nov 08 2018 10:13 AM - edited Nov 08 2018 10:21 AM
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 Sub
an incomplete code that does not run
try to repair Office, uninstall and install it, delete the settings in the registry and nothing worked.
Nov 08 2018 04:37 PM
the following is what I got..
Sub Macro1()
'
' Macro1 Macro
'
'
Range("F6").Select
ActiveCell.FormulaR1C1 = "=1"
Range("F7").Select
End Sub
Nov 08 2018 04:46 PM
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
Nov 08 2018 04:55 PM
Nov 09 2018 03:15 AM