I use above code to enter formula in cell E2, after running VBA code, the cell E2 is =@SORT(FILTER($N$2:$N$1048576,$N$2:$N$1048576>0),1,1) , no idea where @ comes from. I will need to manually remove @ , then the sorted data will be displayed.
Please Login or Register to view this content.
How to fix VBA code?
Thanks.
The "@" symbol is inserted into the formula because Excel is interpreting the formula as an array formula.
When you use SORT and FILTER functions together, Excel treats it as an array formula by default, which is indicated by the "@" symbol.
However, in this case, you don't want it to be treated as an array formula.
To fix this issue, you can use the .Formula2 property instead of .Formula property.
This property allows you to set the formula without the array formula syntax. Here's the modified code:
Using .Formula2 instead of .Formula should prevent Excel from inserting the "@" symbol into the formula, and your sorted data should be displayed correctly.Please Login or Register to view this content.
Quang PT
Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks