Your macro has a lot of extra statements which are not necessary. Can you list out exactly what you want the macro to do (step by step) and we can help you make your macro efficient as well as autofill till the last active cell.