View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael G Michael G is offline
external usenet poster
 
Posts: 2
Default Macro to insert page breaks when values in 1 or more columns changes

I have spreadshete that uses MS Query to load data. The
data needs page breaks when values change in some key
columns. How do I write a macro that scans the key columns
and inserts a horizontal page break when the values change.