I'm writing a VBA program that extracts data from an AutoCAD drawing and
imports it into excel. The worksheet is then printed onto sheets of
labels. There may be as many as 10 sheets of labels in a worksheet.
There are various printers throughout the facility that can be used to
print the labels.

Instead of trying to write code that formats the worksheets for the
particular active printer (the settings for every printer are a little
different), I decided to insert page breaks.
Unfortunately, the hpagebreak command doesn't seem to do anything. It
appears as though the default Excel settings override the VBA page
break functions.

If I adjust the margins, the page breaks follow the margins, but not
what is specified with the hpagebreak code.

How can I use the hpagebreak function to force a page break in a
specific row?

I need to do this in order to get all of the lines of text to appear
properly on each sheet of labels.


--
btm
------------------------------------------------------------------------
btm's Profile: http://www.excelforum.com/member.php...o&userid=24880
View this thread: http://www.excelforum.com/showthread...hreadid=384229