mansure
I would suggest trooping off the David McRitchie's "getting started with
macros" site and read a while then practice.
Make use of the Macro Recorder under Tools<Macro>Record New Macro.
The code produced will do the trick in most cases. It is not the most elegant
code and you will learn how to refine it by watching these news groups,
especially the excel.programming group.
Tushar Mehta has a site that is useful also.
http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm
Shows how to use the recoder and make refinements.
Gord Dibben Excel MVP