VBA syntax to write formula to sheet

[BDrew]

I am attempting to add this formula to the Table of Contents: sheetname("TOC") in column D for a looping routine.
=MATCH("Ω",INDIRECT("'"&TOC!B4&"'!A:A"),1)

I must change "Ω" to ChrW(937) and TOC!B4 to TOC!B & NewRow so that I can increment NewRow=NewRow+1

TOC.Range("D" & NewRow).Formula = "=MATCH(" & ChrW(937) & ",INDIRECT(" & "" &"'TOC!B" & NewRow & "'!A:A"),1)"

the problem starts at INDIRECT(" which excel VBA considers an ending quote and attempting to put more quotes around that isolates the next problem at
'TOC!B which is considered as a note and not part of the formula.

Any assistance would be appreciated.

Brendan

 

[BDrew]

Got it thanks

"=MATCH(" & ChrW(937) & ",INDIRECT( &""" & "'" & "TOC!B" & NewRow & "'!A:A" & "),1)"

Brendan