Hi Dan
When I copy and paste the formula I am not given any error message, instead the formula just becomes entered as text (I can see the formula in the cell rather than a result).
Maybe, when you copy-paste the formula, also copy the "=" signal?? Copy and paste the formula without = and put this in the paste cell.....