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
--
Message posted from
http://www.ExcelForum.com