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.
Something like this.
myvalue stays available troughout the entire sub.
myvalue = InputBox("Which Op Center?") Range("F:F").AutoFilter Field:=1, Criteria1:="=*" & myvalue & "*"
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks