Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

VBA autofilter based on cell value

Comment:

Hi, I would like to autofilter based on a cell value using the filter "contains" as filter. In other words if I for instance want to search for all rows in an autofilter containing the word "VBA" (as an example"), where the value "VBA" has been written in a cell. How would I do that? I know that the code for "contains" would be Criteria1:="=*VBA*", Operator:=xlAnd and that the code for taken the value from a cell woud be: Criteria1:=Range("A1").Text So basically I need to combine the two above and are having difficulties doing it. Can anyone help? Thx. in advance Lars

php access file outside w...

Array and Function

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, Can anyone help me? I need a batch file to replace text base on 2 value on the same line. Thank you. ...

Summary: Is there a way to delete a record in a database based on the date automatically? For example, a bunch of records are added on 02/04/2002, as soon as todays date becomes 02/05/2002 all recors for yeste...

Summary: If I understand you correctly... Yes, this is possible. You can throw a character type cast on your integer. int y = 3; char x = (char) y; This will put the character representation of the number 3 in...