View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RD Wirr RD Wirr is offline
external usenet poster
 
Posts: 55
Default Auto Set Print Area

Can anyone give me a routine for automatically printing a range based on how
many rows of a spread sheet are filled? I think I could set up a dynamic
range to determine all the rows filled with data but then I need a VBA
routine to actaully select that range and set it as the print area and then
print or go into print preview mode. Any help would be much appreciated.
Thanks,
RD Wirr