How can I alter the row heights of all my non empty rows in my EXCEL sheet? Thanks in advance, w.
Select the row or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Row Height. Tip: To quickly autofit all rows on the worksheet, click the Select All button, and then double-click the boundary below one of the row headings.
Try this
sampleRange.Resize.RowHeight=x; //x's type must int
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With