How to fix multiple array formulas showing the #VALUE! error simultaneously?

hi there!

Does any one know how to fix multiple array formulas showing the #VALUE! error simultaneously so I don't have to do it one by one selecting each cell that contains the array formula, press F2 to edit the formula, and then press CTRL+SHIFT+ENTER? Please, any help will be much appreciated. I have hundreds of array formulas on my worksheet showing this error.

One more thing: my array formulas are on a same row... so I can't edit one cell with an array formula, and then pretend to drag the result to the other cells with my mouse. If the formulas were on a column, it would work, but I can't transpose cells as their location on my spreadsheet is important.