Writing a Macro is similar to recording one, except that you are actually writing in commands directly into the Module. It is an intricate procedure and effective with intricate tasks that cannot be recorded. For viewing example codes and script visit Visual Basic Editor Help.