View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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