Ok Problemos. The code that you supplied works when the sheet is not hidden. As soon as i hide the sheet it wont copy. I tried hiding the sheet in excel and also coding it.