The apostrophe in this formula comments out the rest of the line:
ActiveCell.FormulaR1C1 = _
"=INDIRECT(CONCATENATE(" '[filename.xls]",$A$2,"'!$AQ$466"))"
I've tried putting it in double quotes,
"=INDIRECT(CONCATENATE(" "'"[MonthlyTracking.xls]",$A$2,""'"!$AQ$466"))"
but it gives the error "expected end of statement"
Bookmarks