View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Creating Page Break in Print Statement

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