hi everybody
does anybody know how to create a code that:
selects all data (select range that contains data) on the spreadsheet then does print preview and reduces all border margins to minimum desirable range (.04 header & footer, 0.7 top & bottom and 0.5 left and right)?
i tried to record a macro directly from excel (without actually writing a code) but when it's run it gets stuck at print preview screen and doesn't close the screen. also margins seem to be being left at higher range than above.
any help would be greately appreciated
thanks
Bookmarks