Attached is a workbook, with a Test worksheet. This is just a small portion or the 500+ Rows that it has to format and copy. The embedded code takes longer than what it would seem for only 500 rows. Can only feel that the code is not as efficient as it could be for something really simple.
The code works as intended...crearting a sheet of "Labels", so the formatting has to be pretty exact. The reason for the copy and paste is that in the original, there is a formula in each of the cells that point back to the data that is listed on the sheet. So, the copy and paste is also critical, or else done by hand.
Just wanted an Expert to take a look to see if there are ways to improve these few lines of code.