Changing range in VBA to lastrow

Originally Posted by Norie

Does this work?

For Each r In Range("D1:S" & lastrow)

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!