Thread: VBA Totaling
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default VBA Totaling


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.