Thanks Norman.

I have found the root of the problem.... I have a public function
running on every cell in the site stats sheet correcting error fields.


"Public Function derror(v_input As Variant) As Variant
If Application.WorksheetFunction.IsError(v_input) = True Then
derror = 0
Else
derror = v_input
End If
End Function"

When removed the data and values copy correctly.

Thanks for your help.

Kristan


--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=466141