Excel VBA Autofilter on Multiple Criteria

Anyone who has followed my posts on Ozgrid or Chandoo forum will have noticed how frequently I use the autofilter in favour of any kind of loop. I have been lead to believe that in some instances that arrays will perform faster than the humble autofilter however for brevity of code and swiftness I really like the simple elegance of the autofilter. In the article Autofilter on Multiple Conditions I delved into the world of the filer using more than one criteria.

Tags Exce, VB, Autofilter, filter, Multiple, criteria

Excel VBA Filtering on Time

When filtering data the website has focused acutely on filtering information which meets a certain criteria or between two criteria. The site has dealt with filtering on multiple criteria and filtering between dates. Some of these concepts are quite difficult as repeating Excel's tick by filter is not always easy to replicate in VBA. I came across an interesting problem while working for a client. The range of cells had the date and time in the cell, the idea was to get quantity data from a dataset if it was past a certain time.

Tags Excel, Filter, Autofilter, time, Date