That will only work in XL2007 (earlier versions need delimited column ranges
for its arrays). I think I would use delimited ranges even in XL2007
however... not sure how efficient it would be to let array calculations
extend across one million plus rows.
Rick (MVP - Excel)
"Shane Devenshire" < XXXX@XXXXX.COM > wrote in