Yes, it should speed it up somewhat because i believe when you autofill, it keeps recalculating...

You could also try Application.ScreenUpdating = false/true