Thank you for your response. I'm not quite sure your suggestion will work for what I'm trying to do though. I don't care about the ones that are empty and the ones that have more than one element are an array (i.e. I only care about the scalar elements). If I do something like:
Dim Possible(1 To 9, 1 To 9) As Variant Dim L As Long Dim i As Long, j As Long For i = LBound(Possible, 1) To UBound(Possible, 1) For j = LBound(Possible, 2) To UBound(Possible, 2) If Not (IsEmpty(Possible(i, j)) Or InStr(TypeName(Possible(i,j)), "(") > 0) Then 'scalar, do some stuff here End If Next j Next i
will this work the way I expect it to?