I cannot see why you want a macro over a formula, but if you must, create some code to inject the formula, and then value it.