Excel has the ability to write VBA code by recording a Macro. Most (but not all) key strokes are recorded thus enabling you to automate a repetitive task. Unfortunately this method not only produces very inefficient code but is very limited regarding the tasks that you can perform.