Mircrosoft access

[Tido]

i am currently writing vb code in the background of Excel to take query results and format them into an excel spreadsheet so data manipulation can take place instead of just a basic access report. My question is, is there anyway that i can have Excel spit out column Headings at the top of every page when it is sent to the printer(more like an access report) wrather than printing the column headings once and then just spitting out rows of data where by the 10th page you have no clue what each column of numbers is actually representing.

 

[ETID]

Look to the pivot table....

 

[xlbo]

In page setup, set your "Rows to repeat at top" to be your column header row - will then print on every page
HTH
~Geoff~

 

[ETID]

or that...

 

[xlbo]

The syntax would be:
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
End With

assuming column titles in Row1

HTH
~Geoff~