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

Source: spreadsheeto.com

Do until loop vba

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

Source: spreadsheeto.com

Similar codes

0 vote409 views1 answer
Excel vba protect scenarios
VBA
0 vote388 views1 answer
Vba count all row
VBA
0 vote381 views1 answer
Vba ternary
VBA
0 vote353 views1 answer
Excel vba cell on change
VBA
0 vote343 views1 answer
Telephon call in vba
VBA
0 vote514 views1 answer
Amd64 vs arm64 linux
VBA
0 vote358 views1 answer
Vba collection key list
VBA
0 vote449 views1 answer
Vba vbcrlf chr
VBA
0 vote340 views1 answer
Excel vba center userform
VBA
0 vote351 views1 answer
Vba copy file
VBA