Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2014
204
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. Option Explicit
  2. Sub Button1_Click()
  3.  
  4. Dim row As Integer
  5.  
  6. row = 3
  7.  
  8. Do While (Range("A" & row).Value <> "")
  9.  
  10. If Range("A" & row).Value = Range("A1").Value Then
  11. Range("C" & row).Value = Range("B1").Value
  12. End If
  13.  
  14. row = row + 1
  15.  
  16. Loop
  17.  
  18. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement