Using a Macro to Write A Marco

[Bob]

I want to use one macro to write another marco in a
worksheet. What is the code to use for selecting the
worksheet that I want to contain the macro?

 

[Tom Ogilvy]

Look at Chip Pearson's page on this

http://www.cpearson.com/excel/vbe.htm

 

[Amedee Van Gasse]

Look at Chip Pearson's page on this

http://www.cpearson.com/excel/vbe.htm

And don't use McAfee VirusScan ASaP