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:
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