•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#no-code spreadsheet solutions
#Excel alternatives
#VBA
#input box
#Excel
#Excel VBA
#AutoFilter
#ActiveSheet
#criteria
#Criteria1
#hardcoding
#Field
#filtering
#code modification
#name variable