Hi all,
I am a bit new with writing code in excel vba, and I am trying to write a macro that filters an area but everytime there are different number of rows. I have tried doing a trick and selecting an increadibly big range so that it works, but I was wondering if there was a way to do it without ahving to do that trick.
ActiveSheet.Range("$A$2:$AK$25100").AutoFilter Field:=13, Criteria1:= _
"Warrant"
Ideally I would want to get rid of the range or put a range that changes.
Thank you,
Daniel
Bookmarks