Copy values only using vba

[nnish]

I'm trying to copy column B2 to column D2. Column B2 has values formed with formula. I'm copying Column D2 values only using xlPasteValues. But it is not paste the values .
My condition and table attached here with.

[Olly]

Something like:

Please Login or Register  to view this content.

[nnish]

Sir,
I tried ,It is working.But Time will come 0:00:00 New price should be 0.And next day need to take new price to D2.