Excel macro to specify rows and columns to include in printouts

[Generic Usenet Account]

Is there an Excel macro that simulates the effect of specifying the
rows and columns to repeat in a printout? I am looking for something
that simulates the following operations:

1) Page Setup->Sheet [Tab]->Rows to repeat at Top
Highlight the rows

2) Page Setup->Sheet [Tab]->Columns to repeat at Left
Highlight the columns


Thanks,
Gus

 

[Chip Pearson]

Try something like

With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
.PrintTitleColumns = "$A:$A"
End With


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message
news:[email protected]...

 

[JulieD]

Hi Gus

like this:

sub setrepeats()
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
.PrintTitleColumns = "$A:$A"
End With
end sub