Hello snb,

sorry for the confusion. I used the code that you have provided and it worked perfectly as needed. However, I need to send out the worksheet that contains the data from the rows that were splited by the vba command but I'm not sure if its possible to add a button to the worksheet to send it via email.