I can't seem to get the syntax right on this VBA statement:

I want to use a similar statement to :
ActiveCell.FormulaR1C1 = "=PERCENTRANK( R[1]C[6]:R[10]C[6] , R[1]C[6] )"

except that the array parameter "R[1]C[6]:R[10]C[6]" needs to be specified
using row and column variables.

Possibly something close to

ActiveCell.FormulaR1C1 = "=PERCENTRANK( ActiveSheet.Range(Cells(1, 6),
Cells(lastrow, 6)) , R[1]C[6] )"

Can anyone help me fix the syntax or offer another approach? Thanks