I'm trying to format an Excel worksheet but it's not formatting. I'm able to format the column widths but not the options for pagesetup. I'm not gettig an error, but the page is not being formatted. I'm using version 6.2.6. Any suggestions?

                 objExcel.Columns("A:A").ColumnWidth = 18         ' this works
               

                 With objExcel.PageSetup                 'this doesn't work - but no error message

                    .PrintTitleRows = "$1:$1"
                    .PrintTitleColumns = "$A:$A"
                    .Orientation = xlLandscape
                    .PrintGridlines = True
                    .LeftMargin = Excel.Application.InchesToPoints(0.25)
                    .RightMargin = Excel.Application.InchesToPoints(0.25)
                 End With

Thanks

Laura