There are blank cells in the code range so currentregion.copy does not work. Any other ideas?