Help: Filter rows that contain text that starts with the same string

[kotzo]

Hi I'm using the following code to filter specific rows:

   ActiveSheet.Range("$A$1:$L$100000").AutoFilter Field:=1, Criteria1:=a

the variable a should be every string value in column A that starts with the string "Description". The rest of the string differs from row to row.

e.g.

Description Temperature sensor TC600 FeKost 8x50mm
Description Lower section

How can I define variable a in order to show only the rows that
start with the string "Description" ?


Regards,

Kotzo

 

[baitmaster]

Hi, I don't think you can do this exactly, but there is an approach you can take that allows something very similar

See my previous posts both here and here, that describe a tool where you enter any search term, and the autofilter shows only data that matches part or all of that term