Dear, From this video you can learn how use Rept Unfction In Excel. http://www.learn-excel-vba-macro.com/