Quote Originally Posted by BrianMH
[vba]Sub Cname2()

[/vba]
It didn't work. It became empty instead of the result of the formula.