I am working on a vba excel sheet that requires scaling the page at 25%, for this, I used a font size 24.
Now, when I tried to do Range("B2").IndentLevel = 1, it is so perfect in the excel sheet, But when printing the sheet to pdf, I found a lot of wasted space.
Is there any way to control the indent spacing (as far as I know, it accepts only integer numbers, not 0.5 for example), if so, is there any alternative way to minimize the indent and keep it in all lines (Wrap Text)?
Now, when I tried to do Range("B2").IndentLevel = 1, it is so perfect in the excel sheet, But when printing the sheet to pdf, I found a lot of wasted space.
Is there any way to control the indent spacing (as far as I know, it accepts only integer numbers, not 0.5 for example), if so, is there any alternative way to minimize the indent and keep it in all lines (Wrap Text)?