Code Returns The First "T1 - 6" as text and not the value of T1 - 6. Is there a way to tell VBA to return the value of the constructed name and not just the constructed name?
Sub Example()
Dim T1 As String
Dim T2 As String
Dim T3 As String
Dim T4 As String
Dim T5 As String
Dim T6 As String
Dim X As Integer
T1 = "text one"
T2 = "text two"
T3 = "text three"
T4 = "Text four"
T5 = "text five"
T6 = "Text six"
For X = 1 To 6
MsgBox (("T" & X) & " " & T1)
Next X
End Sub
Bookmarks