•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
VBA filter using input box
I'm trying to figure out how to modify the following VBA code to use an input box for the name instead of hardcoding a specific person's name. Everything I've read and tried hasn't worked. Can someone help?
ActiveSheet.Range("$A$2:$KH$1048576").AutoFilter Field:=59, Criteria1:="Name"
[link] [comments]
Want to read more?
Check out the full article on the original site