Problem in linking
Here is my code,
WS2.Worksheets(1).Range("AE" & Lr).Value =
WS1.Worksheets("SUMMARY").Range("C83").Value
WS1.Worksheets("SUMMARY").Range("C83").Value=19%
the problem is when the value retrieve from WS1.Worksheet to WS2.Worksheet,
it become
WS2.Worksheets(1).Range("AE" & Lr).Value=0.186219439996908
i want the value is exactly same with WS1.worksheet
So,do anyone know how to solve this problem?
Thanks...
|