excel vba - How to Auto Filter except a specify a string using VBA? -


in excel file i've hundreds of value including .(dot) values. autofilter values except .(dot) value in vba macro?

not know data, filter on first column rows not start dot:-

activesheet.range("a1:d20").autofilter field:=1, criteria1:="<>.*", operator:=xland 

Comments