excel automation issues

[xxentric]

Hello,

I am having an issues with getting my page setup right... the code below makes excel go crazy and adjusts it to 10% of its normal size and basically every cell is a pagebreak.

        With excelSheet.PageSetup
            .TopMargin = 0.25
            .BottomMargin = 0.25
            .LeftMargin = 0.25
            .RightMargin = 0.5
            .Zoom = False
            .FitToPagesTall = 2
            .FitToPagesWide = 1
        End With

If i comment out the MARGIN changes it works fine and adjusts to about 58% of normal size, but i need to change the margin sizes or else it prints out a bit too small... any ideas?

[xxentric]

i guess to make it more simple... does anyone know why when i try to adjust a margin like...

.TopMargin = excelSheet.Application.InchesToPoints(0.25)

it works fine, unless i set the zoom to fasle like...

.Zoom = False

if i set zoom to false (which i need to do so i can set fitopages) then when i go into print preview, its REALLY tiny, and if i go into pagebreaks, every cell is a page