Here's a good one.
I've copied this date / time from Outlook: "06/05/2011 11:31"
If I use the menu in Excel to Edit... PasteSpecial, I get a choice of Unicode Text, or Text. Either way, Excel gives me 6th of May 2011 (serial 40669), just as I expected.
If I use this code:
ActiveSheet.PasteSpecial
I get 5th June (serial 40699).
How to I get VBA to paste 6th May?
I've copied this date / time from Outlook: "06/05/2011 11:31"
If I use the menu in Excel to Edit... PasteSpecial, I get a choice of Unicode Text, or Text. Either way, Excel gives me 6th of May 2011 (serial 40669), just as I expected.
If I use this code:
ActiveSheet.PasteSpecial
I get 5th June (serial 40699).
How to I get VBA to paste 6th May?
