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
=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