How to copy and paste the date

[clif]

By using the vba , i intend to copy and paste the data into one column, the column next to it is the formula (dateif function) , but it seems the formula is not activated? Could anyone suggest the code? Thank you very much!:banghead:

[Zack Barresse]

Hi there,

It is really not clear what you want. Please be more specific with your requests. Be as absolutely specific as possible, which will help us give you a better and more complete solution.

For the code, well, it depends, but here's some sample code...
DestinationRange.Value = Source.Value

I'm not sure what you mean about the formula is not activated. Is your calculation set to manual perhaps?