Welcome to the OzGrid Forum!
Can you elaborate on your question. Do you mean a worksheet array passed to a VBA routine and you want to know the number of rows and columns in the array? Or you have a variant variable in VBA and you want to know how many entries it contains? Or a dimensioned variable is being passed to another routine and you want to determine how many dimensions it was given? Or ...?