You should have had errors when you ran that code.
Try.You can use a variable as well![]()
With Sheet1 .AutoFilterMode = False .Range("A1:A10").AutoFilter Field:=1, Criteria1:="Job11" End With
You should have had errors when you ran that code.
Try.You can use a variable as well![]()
With Sheet1 .AutoFilterMode = False .Range("A1:A10").AutoFilter Field:=1, Criteria1:="Job11" End With
Last edited by davesexcel; 02-25-2011 at 05:27 AM.
How do I do it as a range? Preferable data entered into a textbox contained in a userform?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks