Quote Originally Posted by Tinbendr
The cursor has to be in the cell containing the data, hence...

AddPara ActiveCell.Text, ActiveCell.Row, ActiveCell.Column
My bad...

I need the data in J to stay the same and the result of the macro to be in column S, and copied down to end row ta