Typed text changes cell

[XDamian]

I created simple macros that do the same thing. A text is typed when clicking on a button that runs my macro.
I created then a macro to delete the texts that I typed.
The texts generated by my macros appear in cells different to those I originally chose when creating my macro.
My Excel version is very old (2003).
Why does my text jump?

 

[MARK858]

I wouldn't imagine that anyone would be able to give a good response until you post your macros

 

[XDamian]

Fair comment!. Macro will be posted.

 

[XDamian]

Sub Clean()
'
' Clean Macro
' Macro grabada el 26/09/2019 por Damian
'
'
Range("G2:G100").Select
Selection.ClearContents
End Sub
Sub A_149_1()
'
' A_149_1 Macro
' Macro grabada el 26/09/2019 por Damian
'
'
ActiveCell.FormulaR1C1 = "Doing a test on macros"
Range("G4").Select
End Sub
Sub A_149_2()
'
' A_149_2 Macro
' Macro grabada el 26/09/2019 por Damian
'
'
ActiveCell.FormulaR1C1 = _
"This text typed in G5 appears in G2 when I activate the macro"
Range("G5").Select
End Sub

Texts are typed in G4 and G5.
Macro is activated with a button that has been created.
Texts appear in some line in the G column.

 

[MARK858]

Your ActiveCell when the text is placed in the cell is G2 because of the first line in your sub where you select the range to be cleared. You don't need to use select.

 

[XDamian]

ok. What can I use instead of select, if I want the cells to be deleted?.

 

[MARK858]

...

Range("G2:G100").ClearContents

Also

Range("G4").Value = "Doing a test on macros"

And the same syntax for G5 if you don't actually need the ActiveCell to change.

 

[XDamian]

...

Range("G2:G100").ClearContents

Also

Range("G4").Value = "Doing a test on macros"

And the same syntax for G5 if you don't actually need the ActiveCell to change.

Thanks, but that does not work.
Syntaxis error.
Thanks for the suggestion.

 

[MARK858]

I can't see any syntax error.

 

[XDamian]

So much better for you ( no syntax error).
Now the text appears wherever it wants.
Thanks for your effort.