The PDF gives you the answer , but it doesn't give you the context . You might find a snippet that works perfectly on your machine but crashes on your colleague's because you didn't understand that it referenced a specific library or a specific file path hardcoded in the macro.
Here is why this massive compendium is one of the most interesting resources for an Excel user. 2,500 excel vba examples pdf