Your write up is somewhat confusing to me. You say "move to the end of the
cell", but I am not sure what you mean by that. You also say "and move to
the next cell in that **row**" (emphasis on the word "row" is mine);
however, your code shows no movement from column to column within the same
row, only movement from row to row. And where did the numbers come from? Are
there more of them? Perhaps if you try describing what you want to do in
more detail, it might help?

Rick


"Jeanne A" wrote in message
...
I'm trying to write a macro to select a cell, move to the end of the cell,
press enter, and move to the next cell in that row & then repeat for all
rows
in that column. Here's what I have so far.

Range("A2").Select
ActiveCell.FormulaR1C1 = "07-30365"
Range("A3").Select
ActiveCell.FormulaR1C1 = "07-40281"
Range("A4").Select
ActiveCell.FormulaR1C1 = "1272-00-02"
Range("A5").Select
ActiveCell.FormulaR1C1 = "1272-00-03"
Range("A6").Select
ActiveCell.FormulaR1C1 = "1272-00-04"
Range("A7").Select
ActiveCell.FormulaR1C1 = "1272-00-05"
Range("A8").Select
End Sub