Im trying to make a macro that creates a sum formula of the cells that have
been selected (like the sum in the status bar) so that I can then click
another cell and paste the resulting formula. I dont know much vba so was
wondering if anyone had some example code that could do this.

Cheers,

Andrew