Skip, cells F7-20,G7-20,H7-20,I7-20,J7-20,K7-20 and L7-20 are being assigned to zero.
Combo, I'll step through the code again and try and see exactly what's going on. It's weird that it works in Excel 2003, but not in Excel 2007.
Thanks for the help, I'll let yo know what I find out.