I am using this command to capture the entry from an input box for a filter.
Range("F:F").AutoFilter Field:=1, Criteria1:="=*" & InputBox("Which Op Center?") & "*"
My Question is, How can I use this same entry for a filename later in the code?
Thank you.
Bookmarks