Help with Formula in Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
have following Code that I would like to modify. So instead of dividing, I
want to Sum but can't seem to get the right logic.
' Dim i as long

For i = 1 To ActiveSheet.UsedRange.Rows.Count
If Cells(i, "A") = "" Then
Cells(i, "o").Value = Cells(i, "I") / Cells(i, "N")
End If
Next
Basically, I want to sum of columns I throuh N where Column A is Blank in
Column O.

Please advise any info would really appreciate it.

Thanks,
Juan
 
Hello JMB,
Thanks alot. Seems to work

Really appreciated the help.

Juan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Totalling then Averaging subject to Product Code change 3
Find #N/A in column D 2
need SUM code help 2
clear all sheets code 4
Modify working code to expand the output. 5
Problem with a loop and column references 27
If column B not empty, value in column A = L 4

Back
Top