VBA Setting Properties in an Array

Hello Uziel,

Your array is actual a Variant that holds a Parameter Array. To declare an Array using the Dim statement, the variable must be followed by parentheses .

Please Login or Register  to view this content.

The reason your array isn't changing the font is the array is loaded with the cell values. The Font Property must be used an object. In this case the object would be the cell which is a Range object. You can change the Font of a contiguous range quite easily, like this...

Please Login or Register  to view this content.

I can NOT use the dim statement and just use Redim

Why not? From Help,

Caution The ReDim statement acts as a declarative statement if the variable it declares doesn't exist at module level or procedure level. If another variable with the same name is created later, even in a wider scope, ReDim will refer to the later variable and won't necessarily cause a compilation error, even if Option Explicit is in effect. To avoid such conflicts, ReDim should not be used as a declarative statement, but simply for redimensioning arrays.

Hello Uziel,

What you have done is legal and you created an array. The point is really one of semantics. Your array has been created using the Array keyword and stored inside a Variant variable. The Dim statement creates a variable that is an array, either static or fixed.