View Single Post
  #1   Report Post  
 
Posts: n/a
Default VBA code to sum a row: syntax needed

I've got some code going, and need to perform a function if the sum of
cells between columns DZ and EP on every row exceeds zero. What is the
code to sum a range?

Range("dz" & selection.row).value + Range("ea" & selection.row).value +
etc is too cumbersome. What's the better way?

Thanks!