i am trying to print an msflexgrid in landscape. i run this code whenever i want to print it:

Printer.Orientation = vbPRORLandscape
Printer.PaintPicture MSFlexGrid1.Picture, 0, 0
Printer.EndDoc

only problem is if i resize the columns then it doesnt print the first two columns and just starts printing the third one at the begining of the page. i'm guessing this is some kind of problem with margins. any help is greatly appreciated. thanks in advance.