I have this recorded macro:
Sub Macro2()
Selection.SpecialCells(xlCellTypeLastCell).Select
Range("I41").Select
Selection.End(xlToLeft).Select
ActiveCell.FormulaR1C1 = "this is a test"
Range("B41").Select
End Sub
How can I get it to go to the bottom of the data regardless of the number of
rows?
Ain't I a dummy??