Paul,

Thanks for that, but I tried commenting that out but it did not make a difference. I've fooled around a bit more with the code and it appears it has something to do with the conditional formatting.

If I comment out the addhighlights portions of the code everything comes out properly aligned, just not with the required shading.

I'm just not sure what is causing the rows to be out of allignment. The conditional formatting is for shading purposes.

Thanks again,

Mike