VBA Make calculation on range

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

Hello,

Is there a way i can make calculations on a range of cells without using
using a for each.. next loop. I want to add 10 to the values in a range. You
can do sheet1.range("A:A") = 10 but you can't do = sheet1.range("A:A") + 10.
 
No loop is needed:

Sub dural()
Set r1 = Range("B1")
Set r2 = Range("A1:A100")
r1.Value = 10
r1.Copy
r2.PasteSpecial Operation:=xlAdd
End Sub
 
Back
Top