activecell (single word not 2) statement

TL Norman For the second question, I am not aware of one source.  However, they are available separately.  For example, Excel functions (alphabetical) and Excel functions (by category) cover the Excel formula side, and Excel object model for Visual Basic for Applications (VBA) covers Excel objects (on the VBA side).  You can see most VBA-accessible properties, methods, and events (each is associated with an object) for Excel objects and other objects right from the Object Browser in the VBA Editor (it's under the View menu); you can use objects from other applications/libraries by adding references in your VBA project via the Tools | References dialog.  For VBA statements, however (such as Dim, Const, Declare, variable assignments, Call), you will need a different source.  I recommend that you browse your local library for a good book, particularly as you should learn object management and error (exception) handling, not just blindly choosing statements with which to experiment.