1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Vba Do Until

[Solved] Vba Do Until | Vb - Code Explorer | yomemimo.com
Question : do until loop vba

Answered by : attractive-anaconda-auyq8jrkli4a

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 : https://spreadsheeto.com/do-loops/ | Last Update : Mon, 04 May 20

Question : do until loop vba

Answered by : attractive-anaconda-auyq8jrkli4a

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

Source : https://spreadsheeto.com/do-loops/ | Last Update : Mon, 04 May 20

Answers related to vba do until

Code Explorer Popular Question For Vb