Daily Dose of Excel recently had a post on interacting with List Objects from VBA.  Since I make very little use of Lists (or Tables as they are now known in Excel, but not VBA), I thought I’d have a search for more information.  There doesn’t seem to be a huge amount of information available, but a good starting point would be:

Working with Tables in Excel 2013, 2010 and 2007 (VBA) from Jan-Karel Pieterse.

See also the first comment below from Winston Snyder, with 6 more List related links.

Other useful links gleaned from DDoE:

EXCELXOR is a relatively new Excel blog with excellent content:

If you’re looking for articles relating to advanced, formula-based Excel solutions then you’ve come to the right place.

Please visit my blog to see a whole host of innovative techniques developed using worksheet formulas alone. These techniques – accompanied by detailed and instructive explanations of their workings – are not only of theoretical interest to the reader wishing to explore the possibilities of what can be achieved in this field, but also offer practical solutions to a plethora of everyday issues which the average Excel user may encounter.

Excellerando has been going for some time.  Not a huge turnover, but over the years it has built up an excellent library of VBA code advice and examples.

Finally another Alfred Vachris link:

VBA Projects by Mark Kubiszyn

Welcome to my blog. This is all about imparting knowledge. I want to share some of the insight and learnings from six years of developing in VBA for Excel. I also want to cover off some innovative techniques, coding best practices and share some of my development Tools & Reports.

Please feel free to download and share my work – you can use the Code and techniques to develop your own VBA Projects. To send me a message, you can contact me on my Homepage