tom88Excel
New Member
- Joined
- Sep 29, 2014
- Messages
- 30
How do I make the output below as "Apple", "Orange", "Pear", "Banana" instead of "Name1", "Name2", "Name3" & "Name4" ?
Also, is there a way to declare a bunch of variables using "to" ? For example, something like Dim ("Name" & 1 to "Name" & 20) as String?
Also, is there a way to declare a bunch of variables using "to" ? For example, something like Dim ("Name" & 1 to "Name" & 20) as String?
VBA Code:
Dim Name1 As String, Name2 As String, Name3 As String, Name4 As String
Name1 = "Apple"
Name2 = "Orange"
Name3 = "Pear"
Name4 = "Banana"
Debug.Print Name1'This one works, but the below don't, why? How do I make this work?
For i = 1 To 6
Debug.Print "Name" & i
Next i