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
|