Quote Originally Posted by Izandol View Post
This is not correct - what was testing you did?
Just playing around with my worksheet and the various suggestions in this post. It's not a difficult macro but we never got it working. Seems to me that's not what this method (Range.Formula) is designed for. As soon as I did a single formula it worked fine. Do you have a working example with multiple formulas? I'm happy to play with that and edit.