Hi all
So i have a attendance sheet in Excel 2003, which feeds the Roll No, Student Name and Class from an Access DB
ex.jpg
In Excel 2003 i could filter the class in cell D2 (the classes here are just a list).
The 'Select Button' had the following Macro
And the ALL button had:![]()
Please Login or Register to view this content.
Now running in Excel 2013 and i get the "Autofilter method of Range class failed"![]()
Please Login or Register to view this content.
Could someone please help me?
Thanks
Bookmarks