Quote Originally Posted by KWMKWM
Doesn't work for me tho in 2010
I assumed you would have > 1 formulae in your "real" sheet.

If you don't - add a dummy formula (doesn't matter what it is), include that cell in your initial selection - then repeat the steps outlined.

If you're applying to a range with > 1 formula and it's still not working post an example that demonstrates it not working.
I confess I've done only limited testing...