Recording macros is an optional feature and is only available if enabled under
Coming from MS Office you may feel lost. Recording is heavily restricted, and recorded macros look basically diferent fro macros you would write on your own line by line. In addition LibreOffice Basic actually is just “another Basic” containing very few additional predefined names (with specic functionality then, of course). Any nontrivial macro having to handle objects for the document will need to use the uno-API, while VBA glues all that into the language.
The LibO macro recorder on the other hand uses a few 1000 predefined routines NOT implemented in Basic, and sparsely (at best) documented. Avoid recording generally, or rework recorded code to better fit into your macros.
What you call “END DOWN” may be what LIbO Calc does if you press
Ctrl+DownArrow. You can record the command. Using the API it’s a bit more complicated