View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt G[_2_] Matt G[_2_] is offline
external usenet poster
 
Posts: 14
Default Format Page breaks

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