Save location based on another cell

Hi so I have this line in my code:

Please Login or Register  to view this content.

But what I want to do is take the "2018" part and change the year based on the value of sheet "Weeks" J2.


This is whole code if needed:

Please Login or Register  to view this content.

i.e if J2 = 2020

then the outputfile would read

Please Login or Register  to view this content.

Many thanks in advance

Perhaps the following?

Please Login or Register  to view this content.

Yes that works great. Took me a while to test but working perfectly

Saved me quite a while in programming.

It won't let me give you reputation as I gave it to you for the last thread but I do really appreciate it.

Glad I could help!