set print area to last occupied row
 

Hey guys i am not sure of the exact programing needed to have a macro set the
print area on one of the worksheets in my workbook. I have a transmittle log
work book and it keeps track of the work done by making a list (WrkLst). I
want to beable to have a macro that will select the work list Alphabatize,
remove dups, and print only to the last row with data. is there any easy
way to do this?

MJ