Forum Discussion
Personalize Output Print based on the las row with data and Printer Setting
Dear All, i have a woorkbook with N sheets i have one file where i can select the sheet to print and use a button to print the sheet i select, i can select also multiples sheets. i am using this...
first of all thank you so much, where i must add the code? thank u for your support and help appreciate
- ok thank you so much, and if i want to print a range from like from A1 to M50 how i can set it please? appreciate
Somewhere between the lines
With ActiveSheet.PageSetupand
End Withinsert
' Set print area .PrintArea = "$A$1:$M$50"- thank you so much, is not working i sent you a dm appreciate