Excel PageBreaks

This is a VBA issue ........I have an Excel spreadsheet that has numerous lines of data per Branch Number......I want to insert a page break at the end of each different Branch Number so that different people can receive individual Branch information.

Using VBA code, how can i insert a pagebreak between different Branch Numbers ???
i.e Branch 1 on one page....Branch 2 on the next...etc,etc

All Branch Numbers are in column A


thanks, in advance

I'm assuming your question is how to insert the page breaks, not how to figure out WHERE to insert them. You really aren't very clear.

1) check the object browser for methods

2) insert a page break manually with the macro capture turned on and look at the code behind the macro

Those are the two techniques you should always start with on office automation questions

I also wanted to know how to find out where...........

....to put the page breaks

i.e. - how to compare the contents of cells