Sub Ent1_1BrUp1stSt()
Dim Conditions1 As String
Dim Conditions2 As String
Dim ConditionsAll As String
Conditions1 = Range("E94").Text
Conditions2 = Range("H93").Text
ConditionsAll = Conditions1 & Conditions2
MessageBox.Show (ConditionsAll)
End Sub
I was expecting this code to output the text in Conditions1 and Conditions2 in a message. E94 = True and H93 = True
I get a Run-time error '424': Object required
Dim Conditions1 As String
Dim Conditions2 As String
Dim ConditionsAll As String
Conditions1 = Range("E94").Text
Conditions2 = Range("H93").Text
ConditionsAll = Conditions1 & Conditions2
MessageBox.Show (ConditionsAll)
End Sub
I was expecting this code to output the text in Conditions1 and Conditions2 in a message. E94 = True and H93 = True
I get a Run-time error '424': Object required