I would like code to enable the user to preview the Print range and once previewed, then to print the range
It would be appreciated if someone could assist me
I would like code to enable the user to preview the Print range and once previewed, then to print the range
It would be appreciated if someone could assist me
change your range as required.
Once opened and happy, click print on the preview screenRange("A1:A6").PrintPreview
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks for the help. I use a user form and the form hangs now when Print Preview is select. I now form to close once Print Preview is selected
Please provide code to do this
If you have a Print Preview Button on your UserForm named "PrintPreview", you could use this for that button.
Attachment 650904Private Sub PrintPreview_Click() Unload Me ActiveSheet.PrintPreview End Sub
Thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks