Simple Macro Failures

[Denny57]

Can someone please advise me if there is some form of configuration which might cause even the simplest macro to Fail.

Working through a basic course I am trying to create the most simple of macros,using the "Record Macro" function in the VB editor. I am simply recording a macro that will copy text into any cell in which the Macro is run. However, the process creates an additional line of code referring to the source cell, regardless of which cell I use to record the macro.

Sub Macro3()
'
' Macro3 Macro

    Range("A1").Select
    ActiveCell.FormulaR1C1 = "Excel VBA"
    Range("A2").Select
End Sub

The text was typed in to Cell A1 and the macro is failing because of the additional first line in the code however, it fails regardless of which cell I use to record the macro.

I need to know if this is a configuration change as otherwise I cannot trust Excel to behave as it should.

Many thanks

 

[Anthony47]

After you started recording the macro:
-you selected A1
-inserted the formula in the selected cell
-automatically the selection moved to the next cell

What has been recorded is correct
If you want the action (insert formula) be excecuted in whichever cell is the active one then just remove Line 1 and Line 3 from the recorded code

 

[Denny57]

Thank You.. This is probably down to a habit of selecting cells whenever I want to use them even when it has already the selelcted cell