C# - Page Breaks In Excel .Net?Mar 25, 2010
I am working with the office interop and am having trouble inserting page breaks in excel. My code is working fine with the horizontal page break but I also need to set the vertical pagebreak My code is below can someone modify it to make a vertical page break on column "I" this code is making the correct horizontal pagebreak but is still 150 pages long because the vertical pagebreak is not set correctly.
Dim r As Excel.Range = CType(xlWorkSheet.Cells(27, 1), Excel.Range)
r.PageBreak = 1