- Aug 21, 2014
Hopefully I can articulate this well. In a macro I use, .Column("X:X") .Delete Shift:x1ToLeft is used, but I've come to a point where the code keeps doing that and will wipe out the middle row due to how it was originally written. These three rows are an example, I think the easiest way would be to shift the cells out to where their counterparts are.
How could I shift cell F2 to R2? and P3 to T3? What do you guys think? And blank cells are fine.
Thank you in advance, -Otto Neidert