Excel - Insert a Page Break?

Hi all:

This might be a dumb question, but I’m new to this so bear with me.

I would like to script Microsoft Excel X to insert a page break at certain rows. I tried recording the action, but it only records the row selection (“Select Range R1”), not the page break command. Is this a bug? I looked at the dictionary and I’m assuming “Insert” is what I want, but I don’t know how to reference the page break.

Any help greatly appreciated.

Thanks in advance.

Have you considered using XML? I have written a couple of XML files for Excel and it is pretty simple to do almost anything. If you are wondering how - just convert a normal excel file into XML (through Excel) and browse through the XML document.