View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default testing cells in a row

If Application.Sum(Range("A10:M10")) "" Then
N10 = Application.Sum(Range("A10:M10"))
End If


"thomas donino" wrote in message
...
I am trying to check whether there are any values in, for example row 10
cells A-M and IF there are any values in ANY of those cells then I will
total
A10:M10 in cell N10. I am having trouble with the IF code for cell N10 to
check the other cells for values