Hi,

I want to assign a formula to a cell. The formula needs to contain a reference to another workbook

recording the macro gives the following:
Range("F8").Select
ActiveCell.FormulaR1C1 = _
"='[Beräkning kreditkostnad FC 4+8 2013.xls]Sammanst'!RC*'Fördelning reserveringar'!R[19]C[4]"

I would like to be able to account for any name changes in the other workbook. Is there any possiblity to handle this,

by e.g. doing something like :

Range("F8").Select
ActiveCell.FormulaR1C1 = _
"=Workbooks(WorkbookFullName).Sheets(Sammanst).RC*'Fördelning reserveringar'!R[19]C[4]"

I cant get it to work