VBA Insert Formula Result Into Cell

Hi, I wonder whether someone may be able to help me please.

I'm using the following code to apply a formula to a given cell:

Please Login or Register  to view this content.

The code and formula work fine, but I'm now trying to change this, so the result of the formula, rather than the formula itself is shown in the cell.

From searching I've done, I thought I may be able to change the formula line to the following, but I try to run this I receive a debug error:

Please Login or Register  to view this content.

I just wondered whether someone may be able to look at this please and let me know where I've gone wrong.

Many thanks and kind regards

Hi @buran, thank you very much for taking the time to reply to my post and for the solution which you've put together, it works just fine.

Once again, many thanks and all the best

Hi @Izandol, thank you very much for taking the time to reply to my post. I did wonder whether the formula may be a little too complex, but as you say the solution from @buran is the way to go.

All the best and kind regards