It didn't work. Whenever I include the sheet location and cell range in the same line of VBA code I always get errors. I decided to select the sheet first then the range. Thanks anyways.