From C# to set and EXCEL page break?

N

newscorrespondent

I am trying to set a page break in EXCEL from a C# application.

Target.ActiveWindow.SelectedSheets.HPageBreaks.Add(??????);

is close to the code that should do it.

The ??? requires a "Before object".

How do I define such an object?

I also can't figure out how to set the font in header object. The EXCEL
macro facility unfortunately leaves that code out when I code a macro.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VSTO C# add in Outlook.Appointment error 0
Need Help with Macro Security 1
Wrapping and Anchors 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA word change keys 0
Loop through pages and insert header image 0
Object Browser in VBA 0
Merging from an Excel file with graphics 1

Top