distinguish Range and "Single"
If (TypeOf Z Is Range) And (Z.Cells.Count1) Then
[Block 2]
Else
[Block 1]
End Fi
does not work if Z is a number (like 0,5). It works with [Block 2] for a
genuine Range (not of 1x1) and with [Block 1] for a 1x1-Range, but no for
numbers with [Block 1].
Why not?
|