>Gregory
>
>Thanks a lot I will try it. Do I put it into my code before or after I have pasted the contents of the clipboard into the worksheet?
>
>Thanks
>
>Colin

Colin,

just tested with _VFP.DataToClip(,,3) + paste in excel

When excel (regional and language options in control panel) is set to british( dd/mm/yyyy ) and vfp set date is DMY no problem

However, when I set vfp to MDY, I see your problem.

I think, then, that your vfp and excel data formats are different (that is why I am filling the cells one by one)

Gregory