Missing a .value here.
.Range("B2:U4").Value = .Range("B2:U4").value
As asked before, if you copy a sheet within the workbook itself are the values in the copy displayed correctly then ?