View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
help help is offline
external usenet poster
 
Posts: 67
Default 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...