View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean P. Dean P. is offline
external usenet poster
 
Posts: 12
Default If Null Set Value to Zero


Please help me modify the VBA code listed below.

If the value for Volume is Null then return a value of zero.

Thanks,



With Sheets("Sheet1")
.Cells(RowCount, "A") = Team
.Cells(RowCount, "B") = Volume
.Cells(RowCount, "C") = Date
End With