Changing range in VBA to lastrow

Originally Posted by pjwhitfield

In your 1st one you're not Autofilling? is that meant to be there in the amended code?

Yeah thats the Original Code
I'm trying to ammend that code to be the second code, but the second code doesn't work.