At the time I need this to run, I have two excel files open. I'm copying data from certain locations on one sheet to the other sheet. The copy part works great. Now I need to do the format part, so I took the macro code and inserted it into my VBA as such.