VBA Sum Non-Contiguous Columns

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

Guest

I'm looking for VBA code to sum columns P and R in column S (sheet 1).
So, cell P2 and R2 will be summed in S2; P3 and R3 summed in S3, and so on.
Thanks!
Exceller
 
Set frng = Range("s2:s" & Cells(Rows.count, "s").End(xlUp).Row)
With frng
.Formula = "=p2+r2"
'uncomment next line to eliminate the formula
' .Formula = .Value
End With
 
Thanks, Don. I appreciate your help.
Exceller

Don Guillett said:
Set frng = Range("s2:s" & Cells(Rows.count, "s").End(xlUp).Row)
With frng
.Formula = "=p2+r2"
'uncomment next line to eliminate the formula
' .Formula = .Value
End With
Click to expand...
 

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

Macro to copy data when data is detected in another column(s). 2
Conditional Formating Issue 1
Multiple SUM's in a column 15
Couple subs need help with 2
need help with macro for 400 worksheets! 2
Setting formulas with R1C1 in VBA and eliminate $ 6
word to excel 1
Sum value in all columns that their title is the same 1

Back
Top