Hi, check my Macro on the "WTD Commentary", I am getting an Application -defined or obeject-defined error.Runtime Error 2004.
Its occuring on the line of code
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-4],'[" & myfilename & "]" & MYSHEETNAME & "'!" & myrangename & ",16,FALSE)"
You need to have both Excel spreadsheets open at the same time when you run the Macro. Any ideas why?