|
|
#1
12-01-2015, 06:37 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2013
Threaded Mode