I have a filter on column A with data ordered (but not grouped) on column B. Can someone suggest code that will insert pagebreaks when the data in column B changes? I'm guessing some sort of For Next loop and a comparison with row against row-1? I'm using Excel 2003 and 2007.