array from range question
i am using this to populate an array
arr = .Range("B12:B" & lRow).Value
then i use this to work with the array
For x = LBound(arr) To UBound(arr)
If arr(x, 1) "" Then
the problem is when lrow = 12 (only 1 element in array), i get a type mismatch.
how can i get around it?
--
Gary
|