If you are using XL2003 or earlier, no... array functions can't use a full
row or column reference in XL2007 you can use it, but you probably
shouldn't... making the array iterate over all the rows in the column is not
as efficient as limiting the iterations over the maximum number of rows that
will ever be used.

Rick

"Blue Fish" wrote in message
...
Thanks a lot for your kindly help. It was quite useful for me!

For remove the limitation of the 3000. Can I use "Sheet-A'!C:C"?