Hi Mike,

It may well be, although like I said, I've been using excel for a while and have always had it copy formulas, yeah it is a bit of a pain, but I can't think of another option unfortunately.

Well I'm running 2010 so it may vary slightly, I've not used the 2007 version so can't say.