Hi
I try read range from column in activesheet to a VBA Array
Filter this array to parameter Match like Not equal array into Filter fucntion.
Please Login or Register to view this content.What is wrong? I'm confusedPlease Login or Register to view this content.
Thnks
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
The 2nd argument needs to be a string, not an array. You will need to loop through the array
Please Login or Register to view this content.
removed - dupe of fluff
Fluff there's no error anymore but the result is wrong
I have a column CFOP
CFOP
'5103
'6103
'6103
'6103
'5103
2204
'5402
'5402
'5402
'5402
'5402
'5103
'5103
'5103
'5103
'5103
I would like this result
CFOP
'6103
'6103
'6103
2204
The code gives me this
5103
5402
Why this code bring me inver result?
With those values i get
6103
6103
6103
2204
Which is what you want.
What code are you using?
This one
Maybe it's because apostrophe in front of the numberPlease Login or Register to view this content.
'5102
'2102
Thanks
Last edited by marreco; 04-29-2020 at 11:55 AM.
Not sure how you got the results you posted with the data shown, as I get
6103
6103
Which is exactly what I would expect. You are just printing the first value in arrCFOP, both times trough the loop.
You need to loop through the array after filtering it to get the full results.
Thank you!!
Please Login or Register to view this content.
You're welcome & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks