Hello all,
I am working on a project in Excel 2010/2007 however the final product will be utilized on a computer that has Excel 2003. I say all this because I think this is the culprit for this error message:
[/B]Run time error '1004' Autofilter method of Range class failed[/B]
and when I debug, it points me to this part of the code:
Range("A3:W3").Select
Selection.AutoFilter
With Selection
.AutoFilter _
Field:=2, _
Criteria1:=DItem 'this set the fist filtered data for the value
End With
Can someone tell me how I can fix this problem? Thnx.
-HP RodNuclear
Bookmarks