Hi Bob,

Thanks for your code but it does not work as I expected.

Thanks.

Tim.

"Bob Phillips" wrote:


"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