I want to make sure I understand. Do you wish to have code to delete columns H, K, N, Q, S and Y? You cannot delete a blank cell with out moving cells that are adjacent to it. Please explain with a clear example of what you are trying to do.