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.
When I try to put that into a cell it skips a letter every 7 columns.
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.
The only reason I can think this is happening is that my dates skip every Sunday, but the code is completely separate.
Bookmarks