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

--
Message posted from http://www.ExcelForum.com

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"trickdos " wrote in message ...
Hey guys, thanks again for all your help...

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

Brett


---
Message posted from http://www.ExcelForum.com/