well, my last post/question fizzled out miserably. so now i am focusing on useing excel as the reporting tool. i have a couple of questions(again).

first one, how do i change the print layout to landscape?

second one, the more important and complicated one....
file->page setup->sheet tab
there is an option for repeating certain cells as headers (rows on top & columns on left). how do i access them from vb?

bear in mind that i will be creating a new excel workbook and worksheet.

any help in this matter will be highly appreciated....