Hello all, I have a sub that is failing on one line and I am not sure
why. The line is
selection.autofilter field:=6, criteria1:= ">500"
the error that I get is autofilter method of range class failed. The
sub is fairly big, that is why I am only posting the one line. if I end
the sub when it fails here I can go and filter the list based on this
exact same criteria. I have used the recorder to make sure that the
line is coded properly. I seems to match what the recorder gives me. Is
there something special that I need to do when using it in code when
comared to doing it manually or recording it?
If more code is needed please let me know and I will post.
Thanks in advance for any help that anyone can provide.
Thanks Terry
Bookmarks