Hi

Double all single " so they read "" and it should work.

HTH. Best wishes Harald

"Deb" skrev i melding
...
The function works in Excel. But, when VB encounters the first quote, it
thinks the rest is a comment. I renamed the spreadsheets to have a
one-level name so that I could remove the single quotes, but it still didn't
work. Help!!

Worksheets("Reformatted Data").Range("D1").Formula =
"=INDEX(INDIRECT("'Downloaded Data'!$A$1:$H$"&'Start
Here'!$E$11),MATCH(I3,INDIRECT("'Downloaded Data'!$I$1:$I$"&'Start
Here'!$E$11),0),4)"