KK1966
10-21-2008, 03:29 AM
Hi
Can someone help me to modify the formula as below as I wanna the value of sheets( ?Discnt?) return value = sum(a2:A70)?
home.Range("R2").Value = Wb.Worksheets("Discnt").Range= sum(a2:A70).Value ---- >> it not work
Please help
Can someone help me to modify the formula as below as I wanna the value of sheets( ?Discnt?) return value = sum(a2:A70)?
home.Range("R2").Value = Wb.Worksheets("Discnt").Range= sum(a2:A70).Value ---- >> it not work
Please help