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

Jack

Maybe this?

Sub Auto_Fill()
Dim Lrow As Long
With ActiveSheet
Range("D1").Formula = "=B1+C1"
Lrow = Range("C" & Rows.Count).End(xlUp).Row
Range("D1" & Lrow).FillDown
End With
End Sub


Gord Dibben MS Excel MVP

On Thu, 14 Jun 2007 11:46:01 -0700, Jack <(E-Mail Removed)> wrote:

>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

Thanks Gord!!!!!!!!!!

"Gord Dibben" wrote:

> Jack
>
> Maybe this?
>
> Sub Auto_Fill()
> Dim Lrow As Long
> With ActiveSheet
> Range("D1").Formula = "=B1+C1"
> Lrow = Range("C" & Rows.Count).End(xlUp).Row
> Range("D1" & Lrow).FillDown
> End With
> End Sub
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 14 Jun 2007 11:46:01 -0700, Jack <(E-Mail Removed)> wrote:
>
> >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
>
>