Hi Marc, thanks for the reply, and the macro.
I actually use the Evaluate function a lot, and your other example is quite straightforward, but there are a couple of things that were not obvious in this code:
- I didn't know that evaluate works as an array function, so you can use it to add or subtract complete columns in one operation. Knowing that, I will probably use it more.
- It isn't clear why you need the .Parent before evaluate.
By the way, I had a look on MSDN. If there is anything there on using Evaluate in Excel VBA, it is very well hidden.