Combining text and data in another cell together

[deduwa]

Hello,

In cell K1 of sheet1 I need to have the wording 'Final Price from xxxx'

The data I need to enter for xxxx will change each week and should reference cell C1 from the LastWk worksheet.

At the moment the below code is failing;

ActiveCell.FormulaR1C1 = "=""Final Price from""&"" ""&"=LstWk!RC[-8]""

Cell C1 in the LastWk tab has the text 31/10 so the result I am looking is 'Final Price from 31/10'

Is anyone able to help?

Thanks

 

[mumps]

Maybe:

Range("K11") = "Final Price from " & Sheets("LstWk").Range("C1")

 

[steve the fish]

Try:

Range("K1").FormulaR1C1 = "=""Final Price from ""&LstWk!RC[-8]"