Incorrect data when using xlset with autofilter

[Guest]

I have a problem when using xlset.
When I try using xlset for fill array of datas. Normally it can work fine.
The problem is occur when I use autofilter feature of excel.
1. I have 25 row * 1 column of datas.
2. Use auto filter of excel, excel might be generate list box for user,
3. Select some chioce that excel create when using autofilter.
4. Using xlset fill array of datas.
xlretSuccess != Excel4(xlSet,&xErr,2,pxRef,&xResult)
Array of data will be filled incorrect cells.
Does anyone have some suggestion to me?
Thank you in advance.

 

[Guest]

For more information,
When I try to use xlcFormula instead of using xlset.
xlcFormula can work fine.

 

[Guest]

Now I have a problem when using xlcFormula.
Can anyone suggest me how to using xlset and xlcformula.
Thanks in advance.