Hi guys,
I have some formulas to work with my worksheet, but because of the amount of data, it takes some time to do the tasks and i'm trying to do in VBA to make it faster.
Now i have this array formula below:
{=INDEX(Dump!J:J,MATCH(I7&"0",Dump!A:A&Dump!J:J,0))}
I want to know if the value of I7 cell on column A, have a "0" on column J.
How can i translate this formula to VBA code ?
Very thanks in advance
Bookmarks