"Tim" wrote in message
...
After I ran the code, I have the following problems.

3. It put "38353" into the cells instead of date value - "mm/dd/yyyy"

Format these cells as dates

4. It put 0 into the cell if the source file's cell is blank.

Suppress zeroes - ToolsOptionsView, uncheck Zero Values