Sometimes you get a “Error 400” generic message from your spreadsheet.
It’s a formula getting crazy or it may be you writing wrong formulas 🙂
Here are a couple solution maight be helpfull: Cells(1, 3).Formula = “=IF(B1>0;A1;B1)” — Error 400 , Avoid Error Displays In Formulas