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:

Please Login or Register  to view this content.

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

Formula:

Please Login or Register  to view this content.

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

Hi jkj115,

It's possible with the indirect formula.
here's an example:

Please Login or Register  to view this content.

More context may be needed.

My first guess at what you want is to use a combination of relative and absolute references =ROWS($G$28:G28). Note the use of an absolute reference to lock one part of the range reference, where the other part is relative. If you are unfamiliar with this most basic concept in spreadsheet programming, I recommend something like this: https://support.office.com/en-us/art...7-6350d512d2dc

thanks GC excel that works