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.