Pagebreak within Excel Sheet

mvdk

Hi there,

I want to transport Navision data to Excel (I use Automation). Everything is going okay, but I want to use Page Breaks
within Excel. I've tried a couple of things but i can't
make it work!

Does anyone know how to use page breaks within Excel?

mfabian

E.g. Page break after Line 45:

xlRange := xlWorksheet.Range('45:45');
xlRange.PageBreak := -4135;


Parameter for Pagebreak:
xlPageBreakAutomatic = -4105
xlPageBreakManual = -4135
xlPageBreakNone = -4142

Marcus

---

Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72

[This message has been edited by fabian (edited 29-11-2000).]