I have a VBA code that selects part of the spreadsheet, and then sets the PRINT AREA to print out a hard copy.
Now I need the selected area printed in a PS file. But couldn't get there yet. I've tried "Save as", but it creates a PS file with the whole spreadsheet.
Any idea would be greatly appreciated. Thanks!