Make ROW function in VBA dynamic from a fixed cell

[akima]

Morning Wizards,

I am using this formula in VBA

=INT((ROW(R[-14]C[-2])-6)/5)+R6C1

Is there a way of making the R[-14] part dynamic based on the number of rows from A6 and cell containing the formula.

Thank you for your help

 

[steve the fish]

Hi try:

"=INT((ROWS(R6C1:RC1)-6)/5)+R6C1"

 

[akima]

Hello Steve,

Thanks for your reply. I am new to this can you break down the formula for me please.