does anyone out here know how to put a variable into a linked formula?
Eaxample:
ActiveCell.FormulaR1C1 = _
"=+'[Estimate Source New Item 1.xls]Estimate (1)'!R9C3"
what I want to be able to do is reference different file names in to link the cells together from workbook to workbook.
Any one have any ideas?
Eaxample:
ActiveCell.FormulaR1C1 = _
"=+'[Estimate Source New Item 1.xls]Estimate (1)'!R9C3"
what I want to be able to do is reference different file names in to link the cells together from workbook to workbook.
Any one have any ideas?