Hi all,

I'm working on a project that allows a user to make some selections in a workbook (Projectxxx), creates a new worksheet to allow more selections, creates a new worksheet to tally, and these tallies are meant to also show up on a second workbook (toolkit). The name of 'toolkit' doesn't vary, but the 'Project...' workbook will be autonamed with the project number.

Recording the macro gives me:
Windows("toolkit.xlsx").Activate
Sheets("Project Summary").Select
Range("D24").Select
ActiveCell.FormulaR1C1 = "='[Project.xlsm]Final Checklist'!R2C10"
Range("D26").Select
ActiveCell.FormulaR1C1 = "='[Project.xlsm]Final Checklist'!R3C10"

Could someone help me out with the syntax for putting in a variable name?
In other parts I've dealt with this by using:

CurrentBook = ThisWorkbook.Name

And then using CurrentBook wherever the filename shows up,

but I don't know how to use CurrentBook when writing a formula into a cell.

Any help?