Advertisement
veronikaaa86

04. SumNumbers

Sep 20th, 2022
1,665
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub SumNumbers()
  2.     Dim n, sum As Integer
  3.     n = Range("A1")
  4.  
  5.     For i = 1 To n
  6.         Dim num As Integer
  7.         num = Range("B" & i)
  8.        
  9.         sum = sum + num
  10.     Next i
  11.    
  12.     Debug.Print sum
  13. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement