Take a look at David McRitchie's "Getting Started with Macros":

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

In article ,
"learner" wrote:

Thanks alot for your suggestions. However, I am not good at programming.
Could you please tell me where should I type the programme you made for me?
Is there any other way of doing it?