Hi,

I'm trying to write a macro that will sort sheet by a particular column "B"
and then llok through that column and set a page break whenever the value of
any row in comumn "B" changes.

For example:
A B C
1 r t g
---------------------- Page Break
2 d u w
3 s u e
---------------------- Page Break
4 e v d

Any Ideas?

Thanks in advance