Hi VZc8, are you any good in creating macros because I'm stuck, my tread is page 3 on the tilte is Microsoft Office Application Help - Excel Help forum » Excel Programming » How to Create a Macro that automatically copies the cells in this range, when typing. Can you help me please.