VBA Totaling

[Steved]

Hello from Steved

Please how does one tell Cell G9 to add Cells G6 and G7 minus G8 to give the
answer in Visual Basic Application.

Thankyou.

 

[Jim Cone]

Not too hard...
Sub AddThemUp()
Dim dblAnswer As Double
dblAnswer = Range("G6").Value + Range("G7").Value - Range("G8").Value
Range("G9").Value = dblAnswer
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Steved"
wrote in message
Hello from Steved

Please how does one tell Cell G9 to add Cells G6 and G7 minus G8 to give the
answer in Visual Basic Application.

Thankyou.

 

[Jim May]

Here's another way:

Sub AddThemUp1()
Range("G9").Formula = "=Sum(G6,G7,-G8)"
End Sub

 

[Steved]

Hello from Steved

I thankyou Both.