Hi all
Is there any command in VBA that enables me to see if the printable sheet fits in width on the first paper with all its columns (Compare usedrange columns with first page columns)? After setting the printable area i would like to know how many columns don not fit on the page, with that information i could decide weather to use FitToPagesWide method or change Left and RightMargins before that.
ty
Is there any command in VBA that enables me to see if the printable sheet fits in width on the first paper with all its columns (Compare usedrange columns with first page columns)? After setting the printable area i would like to know how many columns don not fit on the page, with that information i could decide weather to use FitToPagesWide method or change Left and RightMargins before that.
ty