See David McRitchie's "Getting Started with Macros":


http://www.mvps.org/dmcritchie/excel/getstarted.htm


In article ,
"John" wrote:

How do I create a macro to do this?