Dim args(2) as new com.sun.star.beans.PropertyValue args(0).Name = "PrintArea" args(0).Value = "$A$1:$U$30" args(1).Name = "PrintRepeatRow" args(1).Value = "$A$10" args(2).Name = "PrintRepeatCol" args(2).Value = "" Dim dispatcher as Object dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") dispatcher.executeDispatch(ThisComponent.CurrentController.Frame, ".uno:ChangePrintArea", "", 0, args())