Breaking News: Grepper is joining You.com. Read the official announcement!

do until loop vba

Add Answer

Attractive Anaconda answered on April 27, 2020 Popularity 9/10 Helpfulness 3/10

answer do until loop vba

related vba while loop

related do until loop vba

do until loop vba

Comment

Sub combineNamesWhile()
 i = 2
 Do While Not IsEmpty(Cells(i, 1)) OR Not IsEmpty(Cells(i, 2))
   If IsEmpty(Cells(i, 1)) Then
     Cells(i, 3).Value = Cells(i, 2)
   ElseIf IsEmpty(Cells(i, 2)) Then
     Cells(i, 3).Value = Cells(i, 1)
   Else
     Cells(i, 3).Value = Cells(i, 1) & " " & Cells(i, 2)
   EndIf
   i = i +1
   Loop
End Sub

Popularity 9/10 Helpfulness 3/10 Language vb

Source: spreadsheeto.com

Tags: until-loop vba

Link to this answer
Share Copy Link

Contributed on Apr 27 2020

Attractive Anaconda

0 Answers Avg Quality 2/10

Closely Related Answers

vba while loop

Comment

i = 0
While i < 100
    'Code here is executed 100 times.
    i = i + 1 
Wend

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'Notes: The While loop is terminated with the 'Wend' keyword.
'
'       The While loop must include a Boolean expression directly after
'       the 'While' keyword and the loop will execute for as long as the 
'       Boolean expression evaluates to True. This expression should be
'       based on something that has the POTENTIAL TO CHANGE on each cycle
'       through the loop. For example, 'i' in the above code.
'  
'	    The While expression is evaluated at the beginning EACH cycle through 
'       the loop. The expression DOES NOT NEED to be NUMERIC; but it must 
'       evaluate to True or False. The While loop will be skipped entirely if 
'       the expression evaluates to False before the loop begins.
  
'       The following code demonstrates how the above While loop
'       functions (without actually using the 'While' and 'When' keywords):

i = 0
LoopStart:
    If (i < 100) = False Then GoTo LoopEnd
        'Code here is executed 100 times.
        i = i + 1
    GoTo LoopStart
LoopEnd:  

'      This is for demonstration purposes only. Although these two loops are
'      equivalent, using the 'GoTo' statement should be avoided. The While loop
'      accomplishes the exact same task, but cleanly, without the 
'      line labels and without the 'GoTo' statements.
'
'Note: VBA does not include an 'Exit While' statement to terminate the loop
'      early. VBA does include the 'Exit Do' statement for the Do loop and 
'      also the 'Exit For' statement for the For loop. But it is possible
'      to exit the While loop early with a 'GoTo' statement, but again, the 
'      'GoTo' statement should be avoided. It's also possible to exit
'      the While loop with the 'Exit Sub' and 'Exit Function' statements.
'      But of course, these last two statements will not only exit the
'      While loop, they will also immediately exit the current procedure.
'    
'Note: From an efficiency standpoint, the For loop may be a better choice
'      than the While loop because the For loop's range is calculated only
'      once, before the For loop starts. By contrast, the While loop's
'      expression is evaluated before each and every cycle of the loop.
'
'
'

Popularity 10/10 Helpfulness 5/10 Language vb

Source: Grepper

Tags: vba

Link to this answer
Share Copy Link

Contributed on Oct 18 2020

Excel Hero

0 Answers Avg Quality 2/10

vba while loop

Comment

Sub WhileLoopExample()
    Dim i As Integer
    i = 1
    While i <= 10
        Debug.Print i
        i = i + 1
    Wend
End Sub

Popularity 9/10 Helpfulness 4/10 Language whatever

Source: Grepper

Tags: vba

Link to this answer
Share Copy Link

Contributed on Mar 05 2023

SubZero

0 Answers Avg Quality 2/10

do until loop vba

Comment

Not IsEmpty(Cells(i, 1)) OR Not IsEmpty(Cells(i, 2))

Popularity 9/10 Helpfulness 3/10 Language vb

Source: spreadsheeto.com

Tags: until-loop u

Link to this answer
Share Copy Link

Contributed on Apr 27 2020

Attractive Anaconda

0 Answers Avg Quality 2/10

do until loop vba

Contents

More Related Answers

do until loop vba

Closely Related Answers

vba while loop

vba while loop

do until loop vba

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.