Hi,

These link might help

http://www.contextures.com/xlFunctions02.html

http://www.cpearson.com/excel/duplicat.htm

VBA Noob