I have a workbook that has 2 sheets. The first one contains the current month's activity and at the end of the month that is added to the end of sheet 2 which contains activity for each month of the year. Everything is working great until the last few lines of the code where I am trying to delete the blank lines that were copied over to sheet 2, but since the range changes each month because I'm adding to sheet 2 each time, I don't know how to choose the range and delete the blank lines.
Thank you in advance for any help you can offer.
Sassy2
Thank you in advance for any help you can offer.
Sassy2