Row Heights

[trickdos]

Hey guys, thanks again for all your help...

I am making a workbook and the row heights have to be the same on al
sheets for printing purposes. All sheets are the same format, and i
there a way to make all the row heights the same, without doing i
manually. Thanks.

Bret

 

[Ron de Bruin]

Hi trickdos

You can use this macro

Sub test()
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
sh.Cells.RowHeight = 10
Next
End Sub