How many variables can be declared in a project?
For example I have declared 100 variables as string as below in module1.
Public school1 As String
Public school2 As String
Public school100 As String
And stored strings in those variables in module2 as below.
school1 = "Raleigh, N.C."
school100 = "Colorado Springs, Colo."
And wrote a for each statement
I am always getting "No Matched School" while the selected cells have correct school names. I checked if there is any mistyped words, or any extra spaces or invisible characters. So I doubt declaring 100 variables is not allowed or it does not have capacity to store in memory. I welcome your help and suggestions.