macros

S

Sheeloo

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...

See http://www.anthony-vba.kefra.com/vba/vbabasic1.htm for more details.
 

Ask a Question

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.

Ask a Question

Similar Threads


Top