Dynamic variable name?

[Roderick_E]

Suppose I have undeclared variables called:
config1
config2

How can I make these dynamic in a FOR loop.

For x = 1 to 2
if [COLOR=#ff0000]"config" & x[/COLOR] = "something" then
'do something
endif
next x

 

[Joe4]

It is strongly recommended not to use undeclared variables.
Depending on what you are doing, you may want to consider using arrays instead.

I just showed someone how to set an array and then loop through the values here: https://www.mrexcel.com/forum/excel-questions/1055732-vba-procedure-too-large.html#post5069352

 

[Roderick_E]

yes, thanks I did go with an array solution:

Dim configcnt As Long
Dim configobj As Object
Set configobj = CreateObject("Scripting.Dictionary")
configcnt = 3 'change to reflect number of config elements


'---- MANUAL SETTINGS
configobj(1) = "Inland Source sheet"
configobj(2) = "Analysis sheet"
configobj(3) = "Created Inland Sheet"
'unfilter sheets if filtered
 For x = 1 To configcnt
    If Sheets(configobj(x)).AutoFilterMode Then
    Sheets(configobj(x)).Cells.AutoFilter
    End If
 Next x

 

[Joe4]

You are welcome.