vba

Question

, ( ). , , ? ? , Ubound , , . - Ubound, ?

. , , .

excel vba.

Answer 1

, , , .

, . , .

, . - .

, ubound.

, , . .

Answer 2

ReDim Preserve . , UBound . ReDimmed.

Answer 3

, , , "" . , " ".

Answer 4

, , ...

, :

Public Sub test()
    Dim a(1 To 3)

    a(1) = 1
    a(2) = "stuff"

    Debug.Print Application.WorksheetFunction.CountA(a)
End Sub

'2', 'Empty'. ( , Variant , String. String, !) , , , , , , . 2-D , .

, , , .