N= activesheet.name

[AndyDevine1]

Hi

What is the code change to change 'DataSheet1' to N

where n = activesheet.name


Original code:
Range(Cells(10, 1), Cells(j, 1)).Value = "=IFERROR(INDEX(List!C[1],MATCH('DataSheet1'!RC[4],List!C[1],0),1),0)"

This doesnt work:
Range(Cells(10, 1), Cells(j, 1)).Value = "=IFERROR(INDEX(List!C[1],MATCH('n'!RC[4],List!C[1],0),1),0)"


Many thanks

Andy

 

[FormR]

Hi, if N is the active sheets name and the formula is going in the active sheet then it seems to me that you don't need to include it.

Range(Cells(10, 1), Cells(j, 1)).FormulaR1C1 = "=IFERROR(INDEX(List!C[1],MATCH(RC[4],List!C[1],0),1),0)"

 

[AndyDevine1]

Ah yes of course!! thank you so much!!!