#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Please wrap code with code tags - thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to do this to not to repeat | tommasr | Mail Merge | 3 | 06-03-2014 08:56 PM |
Repeat rows--NOT | markg2 | Excel | 0 | 03-01-2014 11:21 AM |
Repeat formula 5 times and repeat? | Jenny345 | Excel | 4 | 06-14-2013 04:37 PM |
Text will repeat in the fields | ypurcaro | Word | 1 | 02-07-2013 01:46 AM |
how to repeat row in header | gsrikanth | Excel | 10 | 06-28-2012 02:31 AM |