Formula: copy to clipboard
For i = 1 To 5000
If IsEmpty(Selected) = False Then

range("A0" & i).Value = Sheets("Entry").range(Selected & i) & " " & Sheets("Entry").range(Selected & i).Offset(0, 1)



ElseIf IsEmpty(range("Q0" & i)) = False Then

range("Y0" & i).Text = range("Q0" & i).Text

Else


End If

Next i


At line
Formula: copy to clipboard
range("A0" & i).Value = Sheets("Entry").range(Selected & i) & " " & Sheets("Entry").range(Selected & i).Offset(0, 1)
I get the error message "Run-Time Error 13 Type Mismatch" but the entire code still executes normally.