Advice: Macro Cell reference Range vs Active Cell

[mike575]

Here are two examples of just inserting text into cells. The first one was created using the Microsoft suggested fix listed a couple messages above.

Sub Example1()
' Exp1 Macro
' Macro recorded 7/27/2004 by mike
Range("C5").Select
    ActiveCell.FormulaR1C1 = _
        "Cell C5 this macro was created using Microsoft Example of creating a new worksheet"
    Range("C6").Select
    ActiveCell.FormulaR1C1 = "Cell c6 Just befor recording this macro   stop"
    Range("C10").Select
    ActiveCell.FormulaR1C1 = "last cell c10"
    Range("C11").Select
End Sub

This second example was created after looking at the code of the first example. Run the macro a couple of times and and change the active cell by using your arrow keys. see the results change because the starting point changes with the active cell.

Sub Example2()
' Exaample2 Macro
' Macro recorded 7/27/2004 by mike
ActiveCell.FormulaR1C1 = _
        "Cell b14 start  location example of creating a macro without creating a new worksheet first"
    Range("B15").Select
    ActiveCell.FormulaR1C1 = "end b15"
    Range("B15").Select
End Sub