Hi Your Friend,
Is there any site from we can learn making macros with examples......
Visit David McRitchie's 'Getting Started With Macros
And User Defined Functions' at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
You might also look at David's tutorials page at:
http://www.mvps.org/dmcritchie/excel....htm#tutorials
---
Regards,
Norman