Hi everyone,
I'm getting quite confused with a VBA code that i'm trying to implement.
I have a formula which consists out of several concatenated parts, which needs to be assigned to a specific cell:
.Range("C1").Formula="INDEX(E" & Cstr(i) & ":AA" & Cstr(i) & ";1;MATCH($D$17;$E$2:$AA$2;0))"...