Creating Page Break in Print Statement
You could try hex-0C (chr(12) in code).
Nigel wrote:
I am extracting data from a worksheet to a text file using a series of print
statements.
I am using vbCrLf to insert line breaks, how do I insert a page break ?
Although the target file is a text file it will finally be opened in Word
and I need the page breaks to create the pagination. Currently I insert a
dummy character string and use the Word Find and Replace to insert the page
breaks, but this is not ideal.
TIA
--
Cheers
Nigel
--
Dave Peterson
|