Thread: Object doesn't support this property or metheod ERROR
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown[_6_] Gary Brown[_6_] is offline
external usenet poster
  
Posts: 126
Default Object doesn't support this property or metheod ERROR
I don't believe 2003 has the AutoFilter.SORT method, just Application,
Filters, Parent and Range. SORT must have been added in 2007. ???
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Ayo" wrote:

I am having a problem with this line of code.

"pastDueWS.AutoFilter.Sort.SortFields.Clear"

It works fine on my computer, 2007, but not on my boss computer, 2003. Is
there a way to fix this?
Reply With QuoteReply With Quote