Turns out the problem was that in my offset formulas I was inadvertantly
leaving out the single quotes that need to go around the sheet name.
Now it works fine. Doh.


--
jeffsumm
------------------------------------------------------------------------
jeffsumm's Profile: http://www.excelforum.com/member.php...o&userid=29853
View this thread: http://www.excelforum.com/showthread...hreadid=495532