>Trey,
>
>I know I tried ColumnCount = =ALEN(myarray,1) because I am only showing a single column of items, but I still had the repeating problem. But I was thinking for a single column that I could leave off the ",1", but I guess you are telling me that is a potential problem.
>
>I too was thinking the problem had to do with what you just told me, but that doesn't seem to be it. I will double-check that though. Thanks.
ALEN(myarray) gets the total # of elements.
ALEN(myarray,1) gets the # of rows, and still leaves you with the problem
I said ALEN(myarray,
2), which gets the # of columns, which is what you want.
If you only want to show a single column, and you know this already, set the ColumnCount=0.
Insanity: Doing the same thing over and over and expecting different results.