set print area to last occupied row
Hey guys I am not sure of the exact programming needed to have a macro set
the print area on one of the worksheets in my workbook. I have a transmittal
log work book and it keeps track of the work done by making a list (WrkLst).
I want to be able to have a macro that will select the work list Alphabetize,
remove dups, and print only to the last row with data. Is there any easy
way to do this?
MJ
|