I think it's probably because your "infection" and your "conf2" named ranges are no longer the same size.
Assume that "infections" is some thing like 'somesheetname'!A:A, it probably needs to be a dynamic named range too which will always need to be the same length as conf2
I think it's probably because your "infection" and your "conf2" named ranges are no longer the same size.
Assume that "infections" is some thing like 'somesheetname'!A:A, it probably needs to be a dynamic named range too which will always need to be the same length as conf2