I would like to replace all the #N/A values as a "blank"
How to do it ?

I have these few lines of codes

'Vlookup/IndexMatch Active Ext ID
Range("S2:S" & MaxRowNum).Formula = "=INDEX('[PatientMerge.xls]2015'!$J1:$J10000,MATCH(C1:C10000,'[PatientMerge.xls]2015'!$J1:$J10000,0))"
'Vlookup/IndexMatch Inactive Ext ID
Range("T2:T" & MaxRowNum).Formula = "=INDEX('[PatientMerge.xls]2015'!$K1:$K10000,MATCH(C1:C10000,'[PatientMerge.xls]2015'!$K1:$K10000,0))"