How to get a macro to start in the right spot!

B

buzzled

I have a few macros that I use to input predetermined numbers in cells.

ie:
Sub testmacro()
Range("A3").Select
ActiveCell.FormulaR1C1 = "25"
Range("A4").Select
ActiveCell.FormulaR1C1 = "10"
Range("A5").Select
ActiveCell.FormulaR1C1 = "2"
Range("A6").Select
ActiveCell.FormulaR1C1 = "4"
Range("A7").Select
End Sub

The problem is that if a row is inserted above A3 then I want the macr
to start at A4. In other words I want it to start in the same relativ
cell.

Thank
 
B

billyb

You could give a name to each of your target cell, and that name woul
remain with the cell wherever it goes as a result of insertions, etc.
You can name your ranges in Excel by doing Insert>Name>Define, or yo
can simply select your target cell, type a range name in the Name bo
near the top left of the worksheet screen and (required) press Enter.

billy
 
Top