MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Tom- Macro Question


Posted by Brett Holcomb on October 24, 2001 6:26 PM

Tom,

That Macro looks great except that VBA doesnt like the line: Selection.AutoFilter. Field:=2, Criteria1:="10", Operator:=xlBottom10Items

When it gets ot this point, it says "Application Defined or Object Defined Error" and highlights that line. Any ideas?

Also, where on the macro am I telling excel that my times are in column B? Sorry you have to go through all of this for me. I just want to make sure I can adapt your macro and not have to keep bugging you
Brett

P.S. You and Richard amaze me, I never thought anyone could know this much about a program...shows what I know. Thanks for taking the time.


Posted by Tom Urtis on October 24, 2001 6:27 PM

See 2890.html

Posted by Richard S on October 24, 2001 6:46 PM

Tom, Space between "AutoFilter." and "Field"?

Posted by Richard S on October 24, 2001 7:28 PM

Shouldn't be a . after Selection.Autofilter (nt)

Posted by Tom Urtis on October 24, 2001 7:59 PM

Re: Shouldn't be a . after Selection.Autofilter (nt)

Thanks Richard. Brett emailed me the file, I got it to work here, and I emailed it back to him tonite. It was working for me when I sent it to him orgianlly, so this looks like a case of posting code on the internet and it not ending up the same way in another person's module.

In any case, I think this is a done deal. Thanks a lot for helping me with this.

Tom Urtis

Posted by Brett Holcomb on October 25, 2001 2:30 PM

Problem Solved- Thanks Tom and Richard

Tom and Richard- Thanks a ton for helping me to solve my query problems. The issue is resolved, the sheets look great. i really appreciate the help and am very impressed with both of your knowledge.