View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MyKeyJ MyKeyJ is offline
external usenet poster
 
Posts: 7
Default 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