If it is the same formula in each cell, can't you just ensure that is
has been entered correctly in the first cell, and then copy down to
the other cells?

Hope this helps.

Pete

On Aug 19, 3:49*pm, Jennifer
wrote:
I have a range of cells, over 500, that all have array formula. Is there an
easy and fast way to check without error ifall the formulas were enterd as an
array ? Using ctrl ` is to time consuming and room for error when checking
the range.