Rapco, I'm afraid that there is no quick way the macro programming. You need to get to grips with the basic language, and the link to the wiki documentation is at the top of this forum. There is also a slightly older PDF version called the Staroffice 8 Programmer's guide, and you will also need to be familiar with the API as documented in the SDK, which is also downloadable from the OOo site. At 20,000 feet OOo Basic and VBA are broadly similar, however there are many differences between the Excel DCOM API and the Calc UNO API, though Noel Power from Novell is leading a project to provide VBA compatibility within calc. if you search of the OOo wiki, then you will find a reference to this if you search it for VBA.
However I recommend that you get to grips with the native UNO API. One of the key differences between Excel and Calc is that Calc uses a concept called a cursor to navigate around a sheet. I could give you the code fragment to do this but instead why not Google "openoffice calc cursor gotoend" and work it out yourself
PS. B****r, UROS beat me to it with the simple answer
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.