View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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