You're welcome.
Recording a macro can be a useful step in discovering the syntax for an action, but the code produced, if any, will be of inferior quality.
The VBA editor has some tools that can help you learn and which are only a keypress away.
- F1, when the cursor is in a keyword, brings up the online documentation.
- F2 displays the Object Browser which can help you to discover the objects, their methods, properties, and events, that you can work with. You can either browse the object tree or use the find button to discover potentially useful properties or methods. In the 30+ years that I have been writing VBA this has always been the most helpful tool for me.