View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jason Hancock Jason Hancock is offline
external usenet poster
 
Posts: 13
Default Summing every third cell

I've put this together, however I'm getting a runtime error 1004.
Anything I'm missing?

For i = 2 To 233 Step 3
For n = 3 To 15 Step 1
Cells(236, n).Formula = sSum = sSum +
Application.Sum(Range(n & i))
Cells(236, n).NumberFormat = "$#,##0_);[Red]($#,##0)"
Next
Next


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!