One way is to Tools|Macro|Record a macro, give it a name and
then do the steps you want. Once done select Tools|Macro|Stop Recording
You can choose Tools|Macro|Macros and Edit the macro you created to see the
steps. In the Visual Basic Editor enter
Sub nameofyournewmacro and press enter
now you can enter the VBA code for your macro between Sub and End Sub...
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.