View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
kaja kaja is offline
external usenet poster
 
Posts: 9
Default sum by coding without 0

hi

in the following program if there is no value in the cells a1 and b1
it returns 0

Public Sub Add2Cells()
Range("C1").Value = Range("A1").Value + Range("B1").Value
End Sub
i need only the output if the both the cells have the data will you
can tell me that