- or download this
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$2"
.PrintTitleColumns = ""
.PrintArea = "$B:$I"
End With
- or download this
my $pl = "";
open(TXT, "<mymacro.txt");
...
open(TXT, ">mymacro.pl");
print TXT $pl;
close(TXT);
- or download this
$Range = $ActiveSheet->PageSetup;
with ($Range,
...
PrintTitleColumns => '',
PrintArea => '$B:$I',
);