copy it to a regular code module http://www.contextures.com/xlvba01.html copy the sample code into your files code on each worksheet code on each worksheet code on each worksheet stored on the code module copy it to a regular code module stored on the code module http://www.contextures.com/xlvba01.html Excel VBA code Excel VBA code copy it to a regular code module code on each worksheet code on each worksheet stored on the code module http://www.contextures.com/xlvba01.html stored on the code module stored on the code module code to a regular module code to a regular module regular worksheet module stored on the code module copy it to the worksheet module stored on the code module paste it onto the worksheet module copy it to a regular code module added a new section code on each worksheet code on each worksheet Excel VBA code added a module to the workbook stored on the code module to the worksheet module stored on the code module code to a regular module added a module to the workbook instructions on my website Adding Code to a Workbook stored on the code module code to a regular module stored on the code module stored on a regular code module code to a regular module regular worksheet module code on each worksheet code on each worksheet how to insert code code on each worksheet to the worksheet module code on each worksheet code on each worksheet code on each worksheet code on each worksheet code on each worksheet code to a regular module code on each worksheet stored on the code module code on each worksheet http://www.contextures.com/xlvba01.html macro into a regular code module copy it to a regular code module stored on the code module copy it to the worksheet module code on each worksheet copy it to a regular code module http://www.contextures.com/xlvba01.html macro into a regular code module copy it to a regular code module instructions on my Contextures website http://www.contextures.com/xlvba01.html added a module to the workbook copy and paste the Excel code code to a regular module code to a regular module code to a regular module code to a regular module copy and paste the Excel code stored on a regular code module Visual Basic Editor added a module to the workbook to the worksheet module code to a regular module instructions on my website copy and paste the Excel code copy the code to a regular code module added a module to the workbook Adding Code to an Excel Workbook code to a regular module code to a regular module code on the worksheet module regular worksheet module http://www.contextures.com/xlvba01.html http://www.contextures.com/xlvba01.html to the worksheet module code on each worksheet copy it to a regular code module regular code module code on each worksheet code on each worksheet code on each worksheet copy it to a regular code module copy it to a regular code module copy it to a regular code module code on each worksheet stored on the code module code on each worksheet code on each worksheet to the worksheet module copy it to a regular code module code on each worksheet code on each worksheet regular code module copy it to a regular code module code on each worksheet to the worksheet module code on each worksheet copy it to a regular code module code on each worksheet added a module to the workbook code on each worksheet copy it to a regular code module code on each worksheet code on each worksheet code on each worksheet http://www.contextures.com/xlvba01.html code on each worksheet added a module to the workbook code on each worksheet copy it to a regular code module code on each worksheet Adding Code to an Excel Workbook worksheet module worksheet module cool Canadian over at Contextures