When I had to spend a large amount of intimate time with VBA I used to go to
http://www.cpearson.com/Excel/Topic.aspx
Old websites but in my case I dealt with Office <= 2003
http://www.cpearson.com/Excel/Topic.aspx
Old websites but in my case I dealt with Office <= 2003