|
Print Area |
► |
Select a range you want to print first
then, as this menu has an arrow you know it has
sub-menus
-
Set print area
-
Clear print area
VBA |
Sub SetPrintArea()
Dim mySheet As Worksheet
Set mySheet = ActiveSheet
'Set the print area to the range A1:Z100
With mySheet.PageSetup
.PrintArea = "$A$1:$Z$100"
End Withth
End Sub |
