hi, all
can you help me?
i have macro which filtered data based my condition in active column.
but it sometimes doesnt works.
pls. why ?
f.e. if i have autofilter only in selected range of cell not in whole table it gives me an error -
e:1004
autofilter method of range class failed
or
sometimes it filter not in active column but in previous or next column
[vba]Sub filter_show_BLANK()
'
' Macro recorded 14.1.2009 by Vráblik
'
Columns(ActiveCell.Column).AutoFilter Field:=ActiveCell.Column, Criteria1:=""
[/vba]
my code: