Variable from multiple string

Hi

I have many string variables named like : c1, c2, c3, c4, c5 ... and I would like to test them all at the same time with a command like that :

for i = 1 to 100 (number of variables)
if (c+i) = "xxxxxx" then
..........
end if
next i

How can I do that ? If (c+i) doesn't work.

Thanks for helping

Make an array of strings variable instead of many string variables.

VB Code:

Dim c(100) AS String
 
for i = 1 to 100 
  if c(i) = "xxxxxx" then
    ..........
  end if
next i