Variable within the code

[ngedwin]

Hi, i got many variables in the code e.g. Class1, Class2, Class3 .....

I want to use "For Next" loop to do something to every Class

but if i use

-----------------------------------------------
dim class1 as variant
dim class2 as variant
....

dim i as integer

for i=1 to 5

Class & i=.......(code goes here).......

next

 

[Anne Troy]

Just a guess, but I wouldn't use the word "class" as a variable name. It
also happens to be a module type, and it *could* be getting you into
trouble. But I'm no coder, really.


*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Bob Phillips]

Use an array

Dim myClass As Variant

Redim myClass(1 To 5)
For i = 1 To 5
myClass(i) = '....
Next i

--

HTH

RP
(remove nothere from the email address if mailing direct)