I found that the best documention for Excel (or any VBA stuff) is to record macros in the different programs to find the specific sentax. It works half of the time. In fact, I find that VBA documentation as a whole is very poor. If you need further help, don't hesitate!

Regards