What does this vba mean????

[MsAlitaY]

What does Dim DC() mean? I'm used to only seeing "Dim as" whatever.

What does this code do?

Dim DC()
ReDim DC(LCol - 6)

For i = 0 To LCol - 6
DC(i) = i + 6
Next

 

[Fluff]

Dim DC() is the same as writing Dim DC() as Variant
It is declaring DC as a variant array and the next line is then setting the size of that array

 

[joeu2004]

It might also be noted that in this context, the Dim statement is superfluous. ReDim is a dynamic Dim statement.

The ReDim statement that you present could also be written:

ReDim DC(LCol-6) As Variant
or
ReDim DC(0 to LCol-6) As Variant

I prefer the latter because it makes the lower bound (zero) explicit.

Otherwise, the code can be broken by the addition of an Option Base 1 statement at the beginning of the module, because the code presumes a lower bound of zero (For i = 0 ...).

Of course, for maximum flexibility, we could write:

For i = LBound(DC) to UBound(DC)

But there might be other parts of the code that presume a lower bound of zero.