Answers for "do until loop"

do until loop vba

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

Posted by: Guest on April-27-2020

do until loop vba

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

Posted by: Guest on April-27-2020

Code answers related to "do until loop"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Answers for "do until loop"

Code answers related to "do until loop"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Answers for "do until loop"

Code answers related to "do until loop"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us