PDA

View Full Version : Find and Replace Page Down in excel



68cabrio
06-16-2008, 05:38 AM
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
06-16-2008, 05:57 AM
*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
06-16-2008, 06:16 AM
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 SubCharlize

Bob Phillips
06-16-2008, 06:19 AM
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.



ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ACtiveCell