Find and Replace Page Down in excel

[68cabrio]

Hello,

I have a excel spreadsheet which originates from a csv file originated from an MIS system.


I want to put page breaks into the report and have created a marker (~) in the csv file where I want a page break.

Unlike MS Word there is no Find and replace in excel (that i know) that would allow me to:

1) Find ~
2) Replace PageBreak.

Please help

[Ago]

*cough* Ctrl + H *cough*

but i diont know if its possible to make a pagebreak in excel.
i think the topic has been up but i think its still unsolved.

[Charlize]

[VBA]Sub Page_Break_With_Excel()
Dim mycell As Range
Dim myrange As Range
Set myrange = ActiveSheet.Range("A1:A20")
For Each mycell In myrange
If mycell.Value = "~" Then
'Activate the sheet where you want the
'pagebreaks to be inserted
ActiveSheet.HPageBreaks.Add before:=mycell
End If
Next mycell
End Sub[/VBA]Charlize

[Bob Phillips]

but i diont know if its possible to make a pagebreak in excel.
i think the topic has been up but i think its still unsolved.

[vba]

ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ACtiveCell
[/vba]