I have searched through alot of OZGRID and even found the helpsites revolving around Autofilter, Autofilter-criteria, Autofilter-vba-criteria, Autofilter-vba... and I still could not find a 'stop' if there is no contents.
Basically, I want to be able to Autofilter a specific criteria and copy over to another sheet without the header, then in the first column it'll change the information to a date, then copy back over to a third sheet. I have accomplished all of that.
My problem lies with that if there is no contents when the Autofilter is applied, it will still continue to do the steps and then I have Run-time error '1004' AutoFill method of Range class failed. Because there is no contents it tries to do this.
Any help would be greatly appreciated. I have been going through all the words in my head that maybe someone else had this problem but I could not locate anything that would fall right where I needed it.