this a screen shot of a recorded macro to change date format with a formula. It works but when i run the macro on another workbook that has much less or more lines, its doesnt populate. what do i need to add to the code for it to adapt to any number of lines? thanks in advance