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.

Do you mean vertical pagebreak? If you really want horizontal, then what
row would need to be checked for differences - you description doesn't match
horizontal. Writing a macro requires specific information. What are you
key columns - what condition requires a pagebreak, where is you data located
and so forth.

--
Regards,
Tom Ogilvy

Michael G wrote in message
...
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.

The spreadsheet is sorted by values in columns A, B & C.
When any of the values in these columns change a page
break needs to be inserted. I'm assuming I can select the
range $A,$B,$C , search the range and when there is a
change insert a vertical page break.

-----Original Message-----
Do you mean vertical pagebreak? If you really want
horizontal, then what
row would need to be checked for differences - you
description doesn't match
horizontal. Writing a macro requires specific
information. What are you
key columns - what condition requires a pagebreak, where
is you data located
and so forth.

--
Regards,
Tom Ogilvy

Michael G wrote in
message
...
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.


.