View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jack jack is offline
external usenet poster
 
Posts: 186
Default Adding two columns ...please help

Hi,

I have numbers in Column B and C. I need to see the value of =SUM(B1:C1)
that will appear in cell D1.
the value of SUM(B2:C2) that will appear in D2,the value of SUM(B3:C3) that
will appear in cell D3.
up to the end. I can do it in VBS but I need to know the way to see
SUM(B1:C1) in the Fx window when I'll click on the cell D1 when it's
generated by vbs
I don't know how to code it.
Thanks.
Joe