Okay, I've achieved partial success by changing my column order to add the last column (AB, the one that disappears) twice:
Code:
Const NewOrder As String = "D,E,AD,AE,AF,AC,B,C,F,G,H,I,J,K,L,M,N,P,X,Y,Q,R,S,T,U,V,W,A,AA,O,Z,AB,AB"
I'd like to know if this is a regular thing, or if there's a code change that could correct this. I don't understand Rick's code well enough to understand why it's having this problem.