l4l4l4
09-15-2020, 09:37 PM
Hello all.
I'm trying a VBA formula to filter data. I'm stuck because I cannot comprehend what Excel wants. Here's the formula
Sub CodingFiterData ()
range ("MasterData").AdvancedFilter action:=xlFilterCopy, criteriarange:=range("Criteria"),copytorange :=range("Result"), unique:=false
End Sub
Then when I strated the formula, notification appears like this
2712227123
Since I can't attach the worksheet, so here's the capture file
271242712527126
Can anybody see anything immediatley wrong?
Thanks
I'm trying a VBA formula to filter data. I'm stuck because I cannot comprehend what Excel wants. Here's the formula
Sub CodingFiterData ()
range ("MasterData").AdvancedFilter action:=xlFilterCopy, criteriarange:=range("Criteria"),copytorange :=range("Result"), unique:=false
End Sub
Then when I strated the formula, notification appears like this
2712227123
Since I can't attach the worksheet, so here's the capture file
271242712527126
Can anybody see anything immediatley wrong?
Thanks