Repeating Macro in Excel

[bazev1]

Hi

I've recorded the below very basic macro which works perfectly but I now need this to continue repeating on lots of other data in the same sheet. As I'm fairly new to macros I'm not sure which commands to use to do this - any help would be very much appreciated.

Thanks


ActiveCell.FormulaR1C1 = _
"=SUMPRODUCT(1/COUNTIF(RC[-2]:R[229]C[-2],RC[-2]:R[229]C[-2]))"
ActiveCell.Select
Selection.End(xlToLeft).Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 28).Range("A1").Select


End Sub