Replace a cell reference in a formula with dynamic reference

Hi - I want to change a cell reference in a formula to refer to the row of the active cell. For example

Formula:

=ROWS(G8:G28)

I want to replace "28" with row()..something like

Formula:

="ROWS(G8:G"&row()&")"

I now how to do this in VBA, but is it possible to do in a standard formula?