Hi guys, I'm still learning and I'm not familiar with using loops which I think would be the solution for this issue.
So I have some code here that I wrote but I'm sure there is a much better way to input this using a loop or array:
I have like 20 more lines for this, please help
So I have some code here that I wrote but I'm sure there is a much better way to input this using a loop or array:
Code:
If Range("B9").Value = "" Then GoTo Handler
Else
Line2 = Range("B9").Value & " " & Range("C9").Value & vbCrLf
End If
If Range("B10").Value = "" Then
GoTo Handler
Else
Line3 = Range("B10").Value & " " & Range("C10").Value & vbCrLf
End If
If Range("B11").Value = "" Then
GoTo Handler
Else
Line4 = Range("B11").Value & " " & Range("C11").Value & vbCrLf
End If
I have like 20 more lines for this, please help