Changing range in VBA to lastrow

So i have this VBA code

Please Login or Register  to view this content.

but i want the range of which
"For Each r In Range("A1:Q11").Cells"
to change to last row but the following does not work

Please Login or Register  to view this content.

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.

Essentially i want the range of which the values are placed to be lastrow
so the range would be
"D1:S & Lastrow"

Originally Posted by Norie

Does this work?

Please Login or Register  to view this content.

Or do you only want to loop through a particular column?

huh..... who knew the answer would be so simple.
Thanks that works perfectly haha!