Using Dynamic Range in VBA Formula

Hello everybody.
I have simple formula like:

Please Login or Register  to view this content.

I am using this formula in macro code (somewhere) like:

Please Login or Register  to view this content.

But , I want to use dynamic "lr" (as LastRow) instead of "$G$2:$G$5000" like "$G$2:$G$ & lr" (this doesn't work)just same as "ws.Range("I2:I" & lr)" in the code.

How can it be fixed?

Thanks in advance for any reply and help.

Best regards.

Dear TMS,
Thank you very much.

I'll Never forget this "key solution" .

Regards.