Hi All,

I have around 5,000 cells that I want to change from a formula to an array... is there any way I can do this using VBA?

For example, the formula in cell C13 says "=INDEX(Q2DFExtracts!AP$3:AP$67,MATCH(1,($A$1=Q2DFExtracts!$AJ$3:$AJ$68)*($D$13=Q2DFExtracts!$E$3:$E$68),0))" but it really needs to say "{=INDEX(Q2DFExtracts!AP$3:AP$67,MATCH(1,($A$1=Q2DFExtracts!$AJ$3:$AJ$68)*($D$13=Q2DFExtracts!$E$3:$E$68),0))}" (Array Formula).

The formula in cell C14 says something different from C13: "=INDEX(Q2DFExtracts!AQ$3:AQ$67,MATCH(1,($A$1=Q2DFExtracts!$AJ$3:$AJ$68)*($D$13=Q2DFExtracts!$E$3:$E$68),0))", but it needs to be an array as well.

I've been typing "Clt+Shift+Enter" for a few rows, but there are sooo many more cells.. is there any way I can simplify this process using VBA? For example, can I select range C13:AC17, and then use a macro to convert that area into individual array formulas?

Any tips would be greatly appreciated. Thank you!!