Programmatically inserting a page break
 

I'm working on a worksheet for scheduling rooms that needs to have page
breaks inserted for printing.

I need to search Column A for the text 8:00 PM and then insert a page break
before the next cell that has a new room number in it.

Thanks,

Todd