Hi Mifty

To avoid this copy as values and after the macro is ready format
the date column as you want (manual or also with code)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mifty" wrote in message ...
Hi Ron,

Apologies - no - I posted your original code.

I have some data that doesn't copy over correctly as values, if memory
serves it's date of birth.

Here is actual piece of code

FileNameInA:=True, _
PasteAsValues:=False, _
SourceShName:="Data1", _
SourceShIndex:=1, _
SourceRng:="A:I", _
StartCell:="A4", _
myReturnedFiles:=myFiles

Sorry about that! :-)
--
Mifty


"Ron de Bruin" wrote:

Do you copy only values ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm