Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2015, 06:37 AM
paltser paltser is offline Windows 7 32bit Office 2013
Novice
repeat if
 
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
  #2  
Old 12-01-2015, 09:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline repeat if Windows 7 64bit repeat if Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

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
repeat if Text will repeat in the fields ypurcaro Word 1 02-07-2013 01:46 AM
repeat if how to repeat row in header gsrikanth Excel 10 06-28-2012 02:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft