autofill in macro range is constant- how can I code to be a variable range?

It's easy enough to do, but how do you determine what the last row is? Is there a flag, or some other way to tell? If so, it can likely be incorporated into the macro.