not sure what you're asking either, but dimming the variables like this:
Dim i1, i2, i3, i4, i5, i6, i7, i8, i9, i10, i11, i12, i13, i14, i15 As Long
Dim i16, i17, i18, i19, i20, i21, i22, i23, i24, i25, i26, i27, i28, i29, i30 As
Long

only dims i15 and i30 as long, all of the others are variants.

create a breakpoint on this line, for example:
For i1 = 1 To 26
then click on the view menu and then locals window
execute your code and it will stop at the for line.
look at the variable type in the locals window. they will all show variant
except the 2 that you explicitly set to long.

just some info.
--


Gary


"ytayta555" wrote in message
...
On 2 Sep, 01:54, Greg Glynn wrote:

Thanks for suggestions , Greg .I'll try to apply , but I
don't know where from to begin .