Code changes in messagebox

[Demon4231]

I cannot make any sense of why this is happening. I have a table with dates at the top and a total at the bottom.

If I put the code like this the messagebox displays exactly what I want.

Please Login or Register  to view this content.

When I try to put that into a cell it skips a letter every 7 columns.

Please Login or Register  to view this content.

It goes C, D, E, F, G, H, J, K, L, M, N, O, Q, R, S, T, U, V, X, Y, Z, AA, B (not AB), AC, AE

I, P, W, AB, AD letters are skipped.

Here is the total code, the above code is in the For loop.

Please Login or Register  to view this content.

The only reason I can think this is happening is that my dates skip every Sunday, but the code is completely separate.

[Demon4231]

Ok? Never mind I guess, if I put it in Workbook_Open it works fine, but if its in Worksheet_Activate is messes up.