To add page Break by using Visualbasic for Application in Excel using following code
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=Cells(R,W)
where
R - Row & C-Column
the page break will be added to Activewindows selected sheet before the specific Cell
Cheers
Renugopal D
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment