在VBA宏中复制和粘贴日期值

I have written a macro to copy and paste several cell values from one worksheet to another. This has been successful on all fields except one containing a date value. I have written a macro to copy and paste severa