What add-ins do you recommend?
The ones that I recommend are:
ASAP Utilities – over 300 useful and powerful utilities to fill the gaps in Excel, and automate frequently used tasks.
Name Manager – by Jan Karel Pieterse – how name management should have been.
Rob Bovey’s utilities – general purpose utilities.
Find lost passwords – one of the best password recovery tools from Erlandson Data Consulting.
FindLink – track down links in workbooks. There are other useful add-ins on this page.
J-Walk Enhanced data form – enhanced version of the built in data form.
John Walkenbach’s Power Utility Pack – not free but very good set of tools.
Ron de Bruin – a couple of useful add-ins for Google searching and sending e-mails from within Excel.
For VBA
MZ-Tools – enhancements to make programming in VBA easier.
Rob Bovey’s code cleaner – clean up your VBA projects.
Smart Indenter – tidy up VBA code making it easier to read.