Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 12-01-2015, 06:37 AM
paltser paltser is offline Windows 7 32bit Office 2013
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
Old 12-01-2015, 09:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline repeat if Windows 7 64bit repeat if Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,416
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all

Please wrap code with code tags - thx
Reply With Quote

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 - Senior Forums

All times are GMT -7. The time now is 05:42 AM.

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