using a macro to move a function into excel cell
 

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)"

using a macro to move a function into excel cell
 

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

Only internal instances, and not the first and last...

HTH,
Bernie
MS Excel MVP

using a macro to move a function into excel cell
 

"Bernie Deitrick" <deitbe @ consumer dot org skrev i melding
...
Double all single " so they read "" and it should work.

Only internal instances, and not the first and last...

Roger last. First is not quoted in the initial posting. Double the first
that's in the posting.
<g

Best wsishes Harald