I think I may have fixed it on my own. What I did was to move the lastCol variable to after calling another function. Also, I took the formatting out of the loop and highlighted the entire set of data to format the lines between them. I will mark this as solved for now. I did some research on select case and it might clean the code up a little bit, but based on other people's studies it doesn't seem to speed up the code very much more than if statements. Another thing that I may have benefited from would have been to use an array to copy/paste the data (which wasn't the problem, but I want people to consider that). It saves the screen flashing and performs much faster. Eh, next time.