View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davidm davidm is offline
external usenet poster
 
Posts: 1
Default Array problem: Key words-Variant Array, single-element, type mismatch error


Hi Rowan,


You are dead right! I fell into the hole of unwittingly using th
default Optional Base 0. I have been guilty a few times of thi
careless lapse. As a matter of precaution, I often avoid thi
situation by declaring my one-dimensional arrays as
columnar * Dim xArray( n to 1)* rather than the normal Row Di
xArray(n).

Thanks Rowan.


davi

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=48302