On 2 Sep, 02:48, "Gary Keramidas" <GKeramidasATmsn.com wrote:
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.
look at the variable type in the locals window. they will all show variant
except the 2 that you explicitly set to long.

Thanks so much !
What I need is to work with values from a Range , like
D1:F1 ; now , this macro work with values from cell A1 , A2 ...
.........A30 ;
Can this macro work with values from a range , or only with
value from a cell ?(only with variables)..

I need this code to work to combine the rows with values inside them
in combinatoric order , this is the purpose .