Thread: [Solved] repeat if
View Single Post
 
Old 12-01-2015, 06:37 AM
paltser paltser is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Dec 2015
Posts: 5
paltser is on a distinguished road
Default repeat if

How i can make that go till lastrow.

sub rebeat()

If Range("B5") = 0 Then
Range("C5").Value = Range("A5")
ElseIf Range("B6") = 0 Then
Range("C6").Value = Range("A6")
ElseIf Range("B7") = 0 Then
Range("C7").Value = Range("A7")
ElseIf Range("B8") = 0 Then
Range("C8").Value = Range("A8")
End If

end sub
Reply With Quote