Looks like you found your macro recorder......good. You should take a look at the code I posted as all of the extra selects are unnecessary. Another thing in your code when you select the sheet.....which cell is selected? If if is not the one you want the date in then the wrong cell will get the date.....

compare my code to yours and see if you can understand what is going on. Good to see you are learning something from the exercise.