Long Array Formula VBA

DonkeyOte,

This works just like the long code and works in VBA. However, I am not coming up with the expected results. This refers back to thread 807004 http://www.excelforum.com/excel-prog...html?p=2670272

Thanks again for your comments.